{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "cac3eacf",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-24T10:29:19.478091Z",
     "start_time": "2023-06-24T10:29:16.073986Z"
    }
   },
   "outputs": [],
   "source": [
    "from requests_html import HTMLSession\n",
    "import json\n",
    "import pandas as pd\n",
    "\n",
    "\n",
    "url = \"https://api-c.liepin.com/api/com.liepin.searchfront4c.pc-search-job\"\n",
    "payload = {\n",
    "    \"data\":{\n",
    "        \"mainSearchPcConditionForm\": {\n",
    "            \"city\": \"050020\",\n",
    "            \"dq\": \"050020\",\n",
    "            \"pubTime\": \"\",\n",
    "            \"currentPage\": 1,\n",
    "            \"pageSize\": 40,\n",
    "            \"key\": \"新媒体运营\",\n",
    "            \"suggestTag\": \"\",\n",
    "            \"workYearCode\": \"0\",\n",
    "            \"compId\": \"\",\n",
    "            \"compName\": \"\",\n",
    "            \"compTag\": \"\",\n",
    "            \"industry\": \"\",\n",
    "            \"salary\": \"\",\n",
    "            \"jobKind\": \"\",\n",
    "            \"compScale\": \"\",\n",
    "            \"compKind\": \"\",\n",
    "            \"compStage\": \"\",\n",
    "            \"eduLevel\": \"\"\n",
    "        },\n",
    "        \"passThroughForm\": {\n",
    "            \"scene\": \"condition\",\n",
    "            \"skId\": \"mj3mjyy64uu45jg1qtn9pzprjvuhoyc8\",\n",
    "            \"fkId\": \"mj3mjyy64uu45jg1qtn9pzprjvuhoyc8\",\n",
    "            \"ckId\": \"ih4fd3x0qhs56f3x2u9ne0alw9j14kia\",\n",
    "            \"suggest\": None\n",
    "        }\n",
    "    }\n",
    "}\n",
    "\n",
    "\n",
    "\n",
    "# create an HTML session using Requests-HTML\n",
    "session = HTMLSession()\n",
    "\n",
    "# set the headers\n",
    "headers = {\n",
    "    'Accept': 'application/json, text/plain, */*',\n",
    "    'Accept-Encoding': 'gzip, deflate, br',\n",
    "    'Accept-Language': 'zh-CN,zh;q=0.9',\n",
    "    'Connection': 'keep-alive',\n",
    "    'Content-Length': '491',\n",
    "    'Content-Type': 'application/json;charset=UTF-8;',\n",
    "    'Cookie': 'XSRF-TOKEN=rwWq_CMETmGkTAr-QXDfWA; __gc_id=1774c539e3134a57ac95f8a6b0b36b68; _ga=GA1.1.1803938461.1686227328; __uuid=1686227327926.52; __tlog=1686227327932.66%7C00000000%7C00000000%7C00000000%7C00000000; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1686227328; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1686227450; __session_seq=5; __uv_seq=5; acw_tc=276077d016862291589962587e57fb25d38502e98b7f86bc2bcd36f19eba91; _ga_54YTJKWN86=GS1.1.1686227327.1.1.1686229166.0.0.0',\n",
    "    'Host': 'apic.liepin.com',\n",
    "    'Origin': 'https://www.liepin.com',\n",
    "    'Referer': 'https://www.liepin.com/',\n",
    "    'sec-ch-ua': '\"\"Not.A/Brand\";v=\"8\", \"Chromium\";v=\"114\", \"Google Chrome\";v=\"114\"\"',\n",
    "    'sec-ch-ua-mobile': '?0',\n",
    "    'sec-ch-ua-platform': '\"Windows\"',\n",
    "    'Sec-Fetch-Dest': 'empty',\n",
    "    'Sec-Fetch-Mode': 'cors',\n",
    "    'Sec-Fetch-Site': 'same-site',\n",
    "    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36',\n",
    "    'X-Client-Type': 'web',\n",
    "    'X-Fscp-Bi-Stat': '{\"location\": \"https://www.liepin.com/zhaopin/?city=050020&dq=050020&pubTime=&currentPage=0&pageSize=40&key=%E6%96%B0%E5%AA%92%E4%BD%93%E8%BF%90%E8%90%A5&suggestTag=&workYearCode=0&compId=&compName=&compTag=&industry=&salary=&jobKind=&compScale=&compKind=&compStage=&eduLevel=&otherCity=&sfrom=search_job_pc&ckId=mj3mjyy64uu45jg1qtn9pzprjvuhoyc8&scene=condition&skId=mj3mjyy64uu45jg1qtn9pzprjvuhoyc8&fkId=mj3mjyy64uu45jg1qtn9pzprjvuhoyc8&suggestId=\"}',\n",
    "    'X-Fscp-Fe-Version': '',\n",
    "    'X-Fscp-Std-Info': '{\"client_id\": \"40108\"}',\n",
    "    'X-Fscp-Trace-Id': '967eeb6a-db53-4156-90d1-f805664346a0',\n",
    "    'X-Fscp-Version': '1.1',\n",
    "    'X-Requested-With': 'XMLHttpRequest',\n",
    "    'X-XSRF-TOKEN': 'rwWq_CMETmGkTAr-QXDfWA'\n",
    "}\n",
    "\n",
    "# send a POST request with headers\n",
    "df = []\n",
    "for i in range(4):\n",
    "    payload['data']['mainSearchPcConditionForm']['currentPage'] = i\n",
    "    r = session.post(url, data=json.dumps(payload), headers=headers)\n",
    "    # extract the JSON data from the response\n",
    "    response_data = r.json()\n",
    "    df1 = pd.json_normalize(response_data['data']['data']['jobCardList'])\n",
    "    df.append(df1)\n",
    "# example: print the number of job postings returned\n",
    "# print(response_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "8f5729bb",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[                                           dataParams  \\\n",
       " 0   {\"userId\":\"e2caf11372385bc816c460471bf607a4\",\"...   \n",
       " 1   {\"userId\":\"1e0b4e23c1a8a1cf9b7db259246dbaf9\",\"...   \n",
       " 2   {\"userId\":\"f4d1f78d4a4a4aad415e6e85dd3bd7f2\",\"...   \n",
       " 3   {\"userId\":\"218330ba00edd6dffa450ac44d803cf9\",\"...   \n",
       " 4   {\"userId\":\"ea604555b926fe4c7bed7efb3d58ab91\",\"...   \n",
       " 5   {\"userId\":\"d3bf97791c3c054874a1bb5872669685\",\"...   \n",
       " 6   {\"userId\":\"974987d58cc5a9f3d74d472163534d9a\",\"...   \n",
       " 7   {\"userId\":\"66c85d7992c68c6be52d2ab7555e2316\",\"...   \n",
       " 8   {\"userId\":\"45017f931113f3262d1425f735d6efd8\",\"...   \n",
       " 9   {\"userId\":\"18cc9510a39854993308c6cf969b3f7a\",\"...   \n",
       " 10  {\"userId\":\"2c8115af4c0721c535fabb579e455ce4\",\"...   \n",
       " 11  {\"userId\":\"409fbe030e5a059d1c5aa715c2e15e97\",\"...   \n",
       " 12  {\"userId\":\"5552f9f0a8a1a9b3e3b5f517beb3a4b7\",\"...   \n",
       " 13  {\"userId\":\"31762390fab2c90e8b3b2314c9b9f715\",\"...   \n",
       " 14  {\"userId\":\"eb17f2d1ee565d5058b5d91f3e3009a7\",\"...   \n",
       " 15  {\"userId\":\"53b5120274ff64dcf4879a2a3b99c8b8\",\"...   \n",
       " 16  {\"userId\":\"3797f382cd96b57af1cd49813c0e4887\",\"...   \n",
       " 17  {\"userId\":\"53b5120274ff64dcf4879a2a3b99c8b8\",\"...   \n",
       " 18  {\"userId\":\"990ae5af4b6bec0e6f45eefaaa4fe1f7\",\"...   \n",
       " 19  {\"userId\":\"363dec8c0d7ca3b5b5958e6440b064cc\",\"...   \n",
       " 20  {\"userId\":\"c42dd17367dc569d35aae1fea24cdf2a\",\"...   \n",
       " 21  {\"userId\":\"71d61e78f02b2f67e2f44b9858463fed\",\"...   \n",
       " 22  {\"userId\":\"8b371ff276687067fb7bb63ef6f641a2\",\"...   \n",
       " 23  {\"userId\":\"b7db5c1eca9af9325f5a410008247586\",\"...   \n",
       " 24  {\"userId\":\"1cb09565e1b06fbd2f4098d04cc033d1\",\"...   \n",
       " 25  {\"userId\":\"71d61e78f02b2f67e2f44b9858463fed\",\"...   \n",
       " 26  {\"userId\":\"bc004e81634fdbb0baec320b7b0ac594\",\"...   \n",
       " 27  {\"userId\":\"3f59561a99764f4a48b86a76f3e06ef2\",\"...   \n",
       " 28  {\"userId\":\"b2af9bde7269b4c2b4b2e8dfd96c97f0\",\"...   \n",
       " 29  {\"userId\":\"37d22e9e32bcd9386756075cb8790a78\",\"...   \n",
       " 30  {\"userId\":\"629198c7865cecaf007523dab708d6d4\",\"...   \n",
       " 31  {\"userId\":\"629198c7865cecaf007523dab708d6d4\",\"...   \n",
       " 32  {\"userId\":\"2feebc0c5f8874548dccf6eb5c8b0f72\",\"...   \n",
       " 33  {\"userId\":\"decde489d66aa1d5e7261fe422face82\",\"...   \n",
       " 34  {\"userId\":\"a753f6dda27f5cb894b0346b37497568\",\"...   \n",
       " 35  {\"userId\":\"0377c5772035f5352c74cc0cbaaf57a2\",\"...   \n",
       " 36  {\"userId\":\"d578ab316965aec987f45add5ec8b34f\",\"...   \n",
       " 37  {\"userId\":\"29ff5b2e4e8936f8769209cb09d8e1a3\",\"...   \n",
       " 38  {\"userId\":\"b42557710783c1a480d3d6084e5759dd\",\"...   \n",
       " 39  {\"userId\":\"d3543511be1cf4b0cd3ae5463d5525e2\",\"...   \n",
       " \n",
       "                                              dataInfo  \\\n",
       " 0   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 1   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 2   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 3   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 4   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 5   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 6   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 7   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 8   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 9   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 10  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 11  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 12  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 13  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 14  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 15  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 16  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 17  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 18  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 19  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 20  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 21  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 22  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 23  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 24  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 25  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 26  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 27  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 28  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 29  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 30  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 31  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 32  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 33  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 34  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 35  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 36  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 37  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 38  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " 39  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       " \n",
       "                                            job.labels job.requireWorkYears  \\\n",
       " 0        [新媒体运营, 线上运营, 线下运营, to B, to C, 短视频运营, 教育培训]                 1-3年   \n",
       " 1                                                  []                 3-5年   \n",
       " 2   [新媒体运营, 内容运营, 品牌运营, 策略运营, 自媒体运营, 自媒体平台, 新媒体平台,...                 1-3年   \n",
       " 3               [新媒体运营, 自媒体运营, 新闻类, 粉丝运营, 活动策划, 策略运营]                 3-5年   \n",
       " 4                            [新媒体运营, 短视频, 抖音运营, 护肤行业]                 3-5年   \n",
       " 5   [新媒体运营, 用户运营, 内容运营, 广告投放/流量运营, 信息流投放, 短视频运营, 社...                 3-5年   \n",
       " 6                                           [新媒体运营总监]                5-10年   \n",
       " 7               [内容运营, 渠道推广, 品牌活动, 新媒体运营, 活动运营, 平台运营]                5-10年   \n",
       " 8   [新媒体运营, 自媒体运营, 平台运营, 渠道推广, 新媒体平台, 自媒体平台, 抖音平台,...                 3-5年   \n",
       " 9                                [新媒体运营, 自媒体运营, 粉丝运营]                 3-5年   \n",
       " 10                                      [内容运营, 新媒体运营]                 3-5年   \n",
       " 11  [用户运营, 数据运营, 内容运营, 平台运营, 数据分析, 新媒体运营, 短视频运营, 文...                5-10年   \n",
       " 12  [新媒体运营, IT/互联网/软件, 自媒体运营, 短视频运营, 活动策划, 活动运营, 微...                 1-3年   \n",
       " 13                    [新媒体运营, 策略运营, 品牌运营, 平台运营, 产品运营]                 3-5年   \n",
       " 14                             [文案, kol, 内容运营, 新媒体运营]                 1-3年   \n",
       " 15                       [新媒体运营, 自媒体运营, 新媒体平台, 自媒体平台]                 3-5年   \n",
       " 16                       [新媒体运营, 自媒体运营, 自媒体平台, 新媒体平台]                5-10年   \n",
       " 17                       [新媒体运营, 自媒体运营, 新媒体平台, 自媒体平台]                5-10年   \n",
       " 18  [新媒体运营, 数据运营, 平台运营, 自媒体运营, 抖音平台, 新媒体平台, 社交平台, ...                 3-5年   \n",
       " 19                           [网络营销, kol, 新媒体运营, 整体运营]                 1-3年   \n",
       " 20              [新媒体运营, 整体运营, 文案, 市场策划, 渠道运营, 内容运营管理]                 3-5年   \n",
       " 21  [新媒体编辑, 内容运营, 微信公众号, 小红书平台, 微博平台, 新媒体运营, 新媒体广告...                 3-5年   \n",
       " 22  [新媒体运营, 自媒体运营, 产品运营, IT/互联网/软件, 新闻类, 短视频运营, 线上...                 1-3年   \n",
       " 23  [短视频运营, 内容运营, 自媒体运营, 电子商务, 线上运营, to B, to C, 微...                 1-3年   \n",
       " 24                            [餐饮 生鲜 品牌, 批发/零售, 快消品类]                5-10年   \n",
       " 25  [新媒体运营, 小红书平台, 自媒体运营, 微信公众号, 微博平台, 家装类, 广告/传媒/...                 3-5年   \n",
       " 26                                             [平台运营]                5-10年   \n",
       " 27                              [新媒体运营, 微信公众号, 小红书平台]                 1-3年   \n",
       " 28                               [新媒体运营, 策略运营, 自媒体运营]                5-10年   \n",
       " 29   [新媒体运营, 自媒体运营, 数据运营, 社区/社群运营, 微博平台, 微信公众号, 抖音平台]                 1-3年   \n",
       " 30  [数据运营, 新媒体运营, 新媒体平台, 得物, 小红书, 广告投放/流量运营, 策略运营,...                 3-5年   \n",
       " 31  [内容运营, 平台运营, 网络推广, 新媒体平台, 投放平台, 新媒体运营, 数据运营, 小...                 1-3年   \n",
       " 32                    [新媒体运营, 广告投放/流量运营, 自媒体运营, 装饰装修]                 1-3年   \n",
       " 33  [游戏行业, 新媒体运营, 短视频运营, 社区/社群运营, MCN运营, 抖音平台, tap...                 1-3年   \n",
       " 34            [新媒体运营, 数据运营, 产品运营, 抖音平台, 新媒体平台, 自媒体平台]                 1-3年   \n",
       " 35  [新媒体运营, 内容运营, 策略运营, 渠道运营, 自媒体运营, 活动策划, 短视频运营, ...                 3-5年   \n",
       " 36  [新媒体运营, 内容运营, 活动策划, 策略运营, 短视频运营, 活动运营, 电子商务, 自...                 1-3年   \n",
       " 37    [新媒体运营, 社区/社群运营, 自媒体运营, 产品运营, 数据运营, 策略运营, 数据分析]                 3-5年   \n",
       " 38     [新媒体运营, 教育, 选题策划, 自媒体, 短视频, 新媒体, 公众号运营, 新媒体文案]                 1-3年   \n",
       " 39                                            [新媒体运营]                 经验不限   \n",
       " \n",
       "    job.refreshTime job.jobId           job.title  job.salary  job.dq  \\\n",
       " 0   20230607160435  50472999             抖音短视频运营       8-20k      广州   \n",
       " 1   20230510172530  58454571             新媒体运营总监      30-45k  广州-越秀区   \n",
       " 2   20230531014630  58966549    办公室主管 (偏新媒体运营方向）      12-16k  广州-天河区   \n",
       " 3   20190904120349  23157619             新媒体运营总监       8-12k      广州   \n",
       " 4   20211105113707  44492751         短视频/新媒体运营总监      15-25k  广州-番禺区   \n",
       " 5   20220318152704  48187523             新媒体运营主管       9-13k  广州-白云区   \n",
       " 6   20230610161928  46090803             新媒体运营总监      15-30k      广州   \n",
       " 7   20230224160308  56464437             新媒体运营总监      20-30k  广州-越秀区   \n",
       " 8   20230602101936  58308545             新媒体运营经理      12-18k  广州-天河区   \n",
       " 9   20190824152600  22850875             新媒体运营总监        6-8k  广州-天河区   \n",
       " 10  20230508131553  45902931               新媒体运营       6-10k  广州-天河区   \n",
       " 11  20230531135801  58981351             新媒体运营经理      11-18k  广州-海珠区   \n",
       " 12  20221130163528  54749441  新媒体运营经理（编号D1#0511）      10-20k      广州   \n",
       " 13  20230302120113  56630615      新媒体运营岗(J23353)       8-15k  广州-海珠区   \n",
       " 14  20211109184855  44194679             新媒体运营专员    6-8k·13薪  广州-越秀区   \n",
       " 15  20230525101134  58830033             新媒体运营经理      20-27k  广州-番禺区   \n",
       " 16  20230607110505  58674275             新媒体运营经理      20-30k  广州-番禺区   \n",
       " 17  20230607101611  59141519     新媒体运营经理(J10005)      15-25k  广州-番禺区   \n",
       " 18  20230525151644  58845539               新媒体运营  15-25k·15薪  广州-海珠区   \n",
       " 19  20210118101853  35152639             新媒体运营总监      10-15k  广州-海珠区   \n",
       " 20  20201029153530  33032095             新媒体运营总监       8-13k  广州-海珠区   \n",
       " 21  20230404112611  55878099             新媒体运营经理      18-25k  广州-越秀区   \n",
       " 22  20230612092416  59036631             新媒体运营专员       5-10k  广州-南沙区   \n",
       " 23  20230515135759  58459845             新媒体运营专员       7-10k  广州-南沙区   \n",
       " 24  20230509170428  46711801             新媒体运营经理       8-12k  广州-天河区   \n",
       " 25  20230404112611  56015567             新媒体运营总监      25-40k  广州-越秀区   \n",
       " 26  20230609135020  58308885       新媒体运营经理（周末双休）  12-18k·13薪      广州   \n",
       " 27  20220808102316  51105203             新媒体运营专员   6-13k·13薪      广州   \n",
       " 28  20230425115657  45619913             新媒体运营经理      15-30k      广州   \n",
       " 29  20230410134410  57658103               新媒体运营        6-9k  广州-海珠区   \n",
       " 30  20230412135720  56237809        新媒体运营经理（护肤品）  22-30k·13薪  广州-白云区   \n",
       " 31  20230412135720  55981395        新媒体运营经理（洗护类）  10-20k·13薪  广州-白云区   \n",
       " 32  20230326142743  56797613             新媒体运营经理       7-12k  广州-增城区   \n",
       " 33  20221129150357  54652215             游戏新媒体运营   7-10k·13薪  广州-天河区   \n",
       " 34  20230308144314  56797839             新媒体运营经理       5-10k  广州-增城区   \n",
       " 35  20220506193156  48263967             新媒体运营经理      15-25k  广州-白云区   \n",
       " 36  20220326114011  48420109             新媒体运营经理      25-35k      广州   \n",
       " 37  20220907171017  52454491               新媒体运营       8-13k  广州-天河区   \n",
       " 38  20210220094717  35947671               新媒体运营      12-15k      广州   \n",
       " 39  20210625150535  39763161             新媒体运营策划        5-8k      广州   \n",
       " \n",
       "    job.jobKind  ...  recruiter.recruiterTitle  \\\n",
       " 0            2  ...                        HR   \n",
       " 1            2  ...                             \n",
       " 2            2  ...                       总经理   \n",
       " 3            2  ...                      人事专员   \n",
       " 4            2  ...                    人事行政经理   \n",
       " 5            2  ...                             \n",
       " 6            1  ...                      猎头顾问   \n",
       " 7            2  ...                      人事主管   \n",
       " 8            2  ...                    人力资源经理   \n",
       " 9            2  ...                        HR   \n",
       " 10           1  ...                      猎头顾问   \n",
       " 11           2  ...                      招聘总监   \n",
       " 12           2  ...                      人事经理   \n",
       " 13           2  ...                      招聘经理   \n",
       " 14           2  ...                      人事专员   \n",
       " 15           2  ...                             \n",
       " 16           2  ...                     招聘负责人   \n",
       " 17           2  ...                             \n",
       " 18           2  ...                   hrbp实习生   \n",
       " 19           2  ...                        行政   \n",
       " 20           2  ...                      人事主管   \n",
       " 21           2  ...                    HRBP总监   \n",
       " 22           2  ...                       行政部   \n",
       " 23           2  ...                        经理   \n",
       " 24           2  ...                      HR经理   \n",
       " 25           2  ...                    HRBP总监   \n",
       " 26           2  ...                        HR   \n",
       " 27           2  ...                      HRBP   \n",
       " 28           1  ...                      猎头顾问   \n",
       " 29           2  ...                      招聘专员   \n",
       " 30           2  ...                      招聘主管   \n",
       " 31           2  ...                      招聘主管   \n",
       " 32           2  ...                      招聘专员   \n",
       " 33           2  ...                        HR   \n",
       " 34           2  ...                             \n",
       " 35           2  ...                        学生   \n",
       " 36           2  ...                             \n",
       " 37           2  ...                    人力资源专员   \n",
       " 38           2  ...                        运营   \n",
       " 39           2  ...                        经理   \n",
       " \n",
       "                recruiter.recruiterId         recruiter.recruiterPhoto  \\\n",
       " 0   e2caf11372385bc816c460471bf607a4  62a9c3d83857652feba079bb01u.png   \n",
       " 1   1e0b4e23c1a8a1cf9b7db259246dbaf9  5f8f9868f6d1ab58476f24a008u.jpg   \n",
       " 2   f4d1f78d4a4a4aad415e6e85dd3bd7f2  5f8f9866dfb13a7dee342f1808u.jpg   \n",
       " 3   218330ba00edd6dffa450ac44d803cf9  5f8f9865ea60860b75384fa508u.jpg   \n",
       " 4   ea604555b926fe4c7bed7efb3d58ab91  5f8f986779c7cc70efbf36c008u.jpg   \n",
       " 5   d3bf97791c3c054874a1bb5872669685  5f8f986bdfb13a7dee342f2108u.jpg   \n",
       " 6   974987d58cc5a9f3d74d472163534d9a  559272041db2c659018483f803a.jpg   \n",
       " 7   66c85d7992c68c6be52d2ab7555e2316  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       " 8   45017f931113f3262d1425f735d6efd8  5f8f9865ea60860b75384fa508u.jpg   \n",
       " 9   18cc9510a39854993308c6cf969b3f7a  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       " 10  2c8115af4c0721c535fabb579e455ce4  62b927464188cc38b3bbd9ae01u.png   \n",
       " 11  409fbe030e5a059d1c5aa715c2e15e97  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       " 12  5552f9f0a8a1a9b3e3b5f517beb3a4b7  5f8f9865ea60860b75384fa508u.jpg   \n",
       " 13  31762390fab2c90e8b3b2314c9b9f715  5f8f9865ea60860b75384fa508u.jpg   \n",
       " 14  eb17f2d1ee565d5058b5d91f3e3009a7  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       " 15  53b5120274ff64dcf4879a2a3b99c8b8  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       " 16  3797f382cd96b57af1cd49813c0e4887  5f8f9866dfb13a7dee342f1808u.jpg   \n",
       " 17  53b5120274ff64dcf4879a2a3b99c8b8  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       " 18  990ae5af4b6bec0e6f45eefaaa4fe1f7  5f8f986aea60860b75384fab08u.jpg   \n",
       " 19  363dec8c0d7ca3b5b5958e6440b064cc  606c03ba41d68823662ca06c07u.png   \n",
       " 20  c42dd17367dc569d35aae1fea24cdf2a  5f8f98648dbe6273dcf8515508u.jpg   \n",
       " 21  71d61e78f02b2f67e2f44b9858463fed  63f3aaa75f29d64fed69b8ca08u.png   \n",
       " 22  8b371ff276687067fb7bb63ef6f641a2  5f8f9865ea60860b75384fa508u.jpg   \n",
       " 23  b7db5c1eca9af9325f5a410008247586  64422b4d3d44a535075d886903u.png   \n",
       " 24  1cb09565e1b06fbd2f4098d04cc033d1  5f8f986779c7cc70efbf36c008u.jpg   \n",
       " 25  71d61e78f02b2f67e2f44b9858463fed  63f3aaa75f29d64fed69b8ca08u.png   \n",
       " 26  bc004e81634fdbb0baec320b7b0ac594  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       " 27  3f59561a99764f4a48b86a76f3e06ef2  5f8f98648dbe6273dcf8515508u.jpg   \n",
       " 28  b2af9bde7269b4c2b4b2e8dfd96c97f0  613b1d5f6922c96d6db1726702u.png   \n",
       " 29  37d22e9e32bcd9386756075cb8790a78  5f8f9866dfb13a7dee342f1808u.jpg   \n",
       " 30  629198c7865cecaf007523dab708d6d4  5f8f98648dbe6273dcf8515508u.jpg   \n",
       " 31  629198c7865cecaf007523dab708d6d4  5f8f98648dbe6273dcf8515508u.jpg   \n",
       " 32  2feebc0c5f8874548dccf6eb5c8b0f72  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       " 33  decde489d66aa1d5e7261fe422face82  5f8f9865ea60860b75384fa508u.jpg   \n",
       " 34  a753f6dda27f5cb894b0346b37497568  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       " 35  0377c5772035f5352c74cc0cbaaf57a2  5f8f98648dbe6273dcf8515508u.jpg   \n",
       " 36  d578ab316965aec987f45add5ec8b34f  5f8f98648dbe6273dcf8515508u.jpg   \n",
       " 37  29ff5b2e4e8936f8769209cb09d8e1a3  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       " 38  b42557710783c1a480d3d6084e5759dd  5f8f9868f6d1ab58476f24a008u.jpg   \n",
       " 39  d3543511be1cf4b0cd3ae5463d5525e2  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       " \n",
       "    comp.compId  comp.compScale     comp.compName comp.compStage  \\\n",
       " 0    9681783.0        100-499人  广州时代华商人才培训股份有限公司          新三板上市   \n",
       " 1   13503443.0        500-999人    广州市冠尚玉文化传媒有限公司            NaN   \n",
       " 2   13469371.0          50-99人    广州惠和营销咨询管理有限公司            NaN   \n",
       " 3   10121385.0           1-49人      广东斌锋安全服务有限公司            NaN   \n",
       " 4   12879953.0          50-99人      广州鬼谷信息科技有限公司            NaN   \n",
       " 5   10259381.0        100-499人              致学教育            NaN   \n",
       " 6          NaN                             某知名公司            NaN   \n",
       " 7   12518885.0          50-99人     广州智惠宝网络科技有限公司            NaN   \n",
       " 8    8109875.0        500-999人      海华税务师事务所有限公司            NaN   \n",
       " 9   10121385.0           1-49人      广东斌锋安全服务有限公司            NaN   \n",
       " 10         NaN           1-49人         某广州专业服务公司            NaN   \n",
       " 11  12849281.0           1-49人               点竞石            天使轮   \n",
       " 12   9210474.0        500-999人       广州欧博化妆品有限公司            NaN   \n",
       " 13  13018251.0      1000-2000人   西藏保利爱家房地产经纪有限公司            NaN   \n",
       " 14  12829263.0           1-49人    广州宠小到大智能科技有限公司             其他   \n",
       " 15  13538179.0                             赵一鸣零食            NaN   \n",
       " 16  13233711.0        100-499人             赵一鸣零食            NaN   \n",
       " 17  13538179.0                             赵一鸣零食            NaN   \n",
       " 18  13304915.0        100-499人              超境汽车             B轮   \n",
       " 19  12448117.0           1-49人    广州美逅装饰设计工程有限公司          融资未公开   \n",
       " 20  12448117.0           1-49人    广州美逅装饰设计工程有限公司          融资未公开   \n",
       " 21   8939670.0           1-49人      广州光晨信息科技有限公司          融资未公开   \n",
       " 22  12608599.0           1-49人        广州悦龙印刷有限公司            NaN   \n",
       " 23  12824123.0          50-99人      广州敏耀包装材料有限公司          融资未公开   \n",
       " 24  12852047.0           1-49人       广州古禾供应链有限公司            NaN   \n",
       " 25   8939670.0           1-49人      广州光晨信息科技有限公司          融资未公开   \n",
       " 26   8109875.0        500-999人      海华税务师事务所有限公司            NaN   \n",
       " 27    583122.0      1000-2000人              众上集团          融资未公开   \n",
       " 28         NaN        100-499人        某南京贸易进出口公司          融资未公开   \n",
       " 29  13001749.0      1000-2000人      广东森宝文化实业有限公司            NaN   \n",
       " 30   9283156.0        500-999人               梵蜜琳            NaN   \n",
       " 31   9283156.0        500-999人               梵蜜琳            NaN   \n",
       " 32  12678377.0        100-499人              木瓜家装            NaN   \n",
       " 33  13365479.0          50-99人      广州星游互动网络有限公司            NaN   \n",
       " 34  12678377.0        100-499人              木瓜家装            NaN   \n",
       " 35   9327004.0        100-499人   广州阿道夫个人护理用品有限公司            NaN   \n",
       " 36   9327004.0        100-499人   广州阿道夫个人护理用品有限公司            NaN   \n",
       " 37  13309919.0           1-49人     广州心创供应链管理有限公司            NaN   \n",
       " 38   8955108.0      2000-5000人                希沃           战略投资   \n",
       " 39  12481127.0        100-499人  中旅商务旅行服务(广州)有限公司          融资未公开   \n",
       " \n",
       "                       comp.compLogo                                 comp.link  \\\n",
       " 0   62cbe259e333d8014ebbc41f06u.png   https://www.liepin.com/company/9681783/   \n",
       " 1   6414f294cad5c51171a71ae304u.jpg  https://www.liepin.com/company/13503443/   \n",
       " 2   6413a1c99533bc0e50173d8a05u.jpg  https://www.liepin.com/company/13469371/   \n",
       " 3   61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/10121385/   \n",
       " 4   61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12879953/   \n",
       " 5   60a4747ad2c6470a6cd6e33001u.png  https://www.liepin.com/company/10259381/   \n",
       " 6   60e2fe0bf3df194a3c48adb502u.png                                             \n",
       " 7   61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12518885/   \n",
       " 8   5b7cfda38e504f60e317965d04a.jpg   https://www.liepin.com/company/8109875/   \n",
       " 9   61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/10121385/   \n",
       " 10  60e2fe0bf3df194a3c48adb502u.png                                             \n",
       " 11  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12849281/   \n",
       " 12  5ae933298e50ff6eb70a481605a.jpg   https://www.liepin.com/company/9210474/   \n",
       " 13  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/13018251/   \n",
       " 14  614d717bd66f890bba11c7a503u.jpg  https://www.liepin.com/company/12829263/   \n",
       " 15  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/13538179/   \n",
       " 16  63257a1784b3bb709377be3404u.png  https://www.liepin.com/company/13233711/   \n",
       " 17  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/13538179/   \n",
       " 18  634e43cd5f9dbd49324c45d307u.png  https://www.liepin.com/company/13304915/   \n",
       " 19  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12448117/   \n",
       " 20  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12448117/   \n",
       " 21  5bfe952b74719dc6ed74115303a.png   https://www.liepin.com/company/8939670/   \n",
       " 22  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12608599/   \n",
       " 23  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12824123/   \n",
       " 24  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12852047/   \n",
       " 25  5bfe952b74719dc6ed74115303a.png   https://www.liepin.com/company/8939670/   \n",
       " 26  5b7cfda38e504f60e317965d04a.jpg   https://www.liepin.com/company/8109875/   \n",
       " 27  5bfe9d5a74719d2aa34b5e0903a.png    https://www.liepin.com/company/583122/   \n",
       " 28  60e2fe0bf3df194a3c48adb502u.png                                             \n",
       " 29  61a5bb22f96ca95918aa2e9206u.png  https://www.liepin.com/company/13001749/   \n",
       " 30  60335ea200e91f04c68d28ad02u.png   https://www.liepin.com/company/9283156/   \n",
       " 31  60335ea200e91f04c68d28ad02u.png   https://www.liepin.com/company/9283156/   \n",
       " 32  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12678377/   \n",
       " 33  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/13365479/   \n",
       " 34  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12678377/   \n",
       " 35  59cb4c8870323b4a848b9cb606a.png   https://www.liepin.com/company/9327004/   \n",
       " 36  59cb4c8870323b4a848b9cb606a.png   https://www.liepin.com/company/9327004/   \n",
       " 37  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/13309919/   \n",
       " 38  5948f6cf70320c7ee1a312fc04a.jpg   https://www.liepin.com/company/8955108/   \n",
       " 39  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12481127/   \n",
       " \n",
       "    comp.compIndustry  \n",
       " 0               咨询服务  \n",
       " 1              珠宝/首饰  \n",
       " 2            其他商务服务业  \n",
       " 3             专业技术服务  \n",
       " 4              批发/零售  \n",
       " 5               在线教育  \n",
       " 6             其他生活服务  \n",
       " 7              计算机软件  \n",
       " 8           财务/审计/税务  \n",
       " 9             专业技术服务  \n",
       " 10            专业技术服务  \n",
       " 11              电子商务  \n",
       " 12                日化  \n",
       " 13          房地产租赁/中介  \n",
       " 14              电子商务  \n",
       " 15          食品/饮料/酒水  \n",
       " 16             批发/零售  \n",
       " 17          食品/饮料/酒水  \n",
       " 18              整车制造  \n",
       " 19           房地产开发经营  \n",
       " 20           房地产开发经营  \n",
       " 21               互联网  \n",
       " 22          印刷/包装/造纸  \n",
       " 23          印刷/包装/造纸  \n",
       " 24               餐饮业  \n",
       " 25               互联网  \n",
       " 26          财务/审计/税务  \n",
       " 27          食品/饮料/酒水  \n",
       " 28            贸易/进出口  \n",
       " 29               工艺品  \n",
       " 30                日化  \n",
       " 31                日化  \n",
       " 32              装饰装修  \n",
       " 33                游戏  \n",
       " 34              装饰装修  \n",
       " 35          食品/饮料/酒水  \n",
       " 36          食品/饮料/酒水  \n",
       " 37             批发/零售  \n",
       " 38               互联网  \n",
       " 39            专业技术服务  \n",
       " \n",
       " [40 rows x 31 columns],\n",
       "                                              dataInfo  \\\n",
       " 0   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 1   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 2   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 3   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 4   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 5   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 6   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 7   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 8   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 9   %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 10  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 11  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 12  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 13  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 14  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 15  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 16  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 17  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 18  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 19  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 20  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 21  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 22  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 23  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 24  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 25  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 26  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 27  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 28  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 29  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 30  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 31  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 32  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 33  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 34  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 35  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 36  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 37  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 38  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " 39  %7B%22ckId%22%3A%22ih4fd3x0qhs56f3x2u9ne0alw9j...   \n",
       " \n",
       "                                            dataParams  \\\n",
       " 0   {\"userId\":\"70c98d1ef881f7f352a80d711f42c02f\",\"...   \n",
       " 1   {\"userId\":\"3ecf4d9bd30fc87442d4ca737edf98bb\",\"...   \n",
       " 2   {\"userId\":\"41c625b8269a89bad622b1e8fddbd6d1\",\"...   \n",
       " 3   {\"userId\":\"e325096bfdd827e2e000700da58b1dea\",\"...   \n",
       " 4   {\"userId\":\"1ff8d11c35f0568cc0c3e4af9a479593\",\"...   \n",
       " 5   {\"userId\":\"8c3ad676f680b94377a5ce05d35d50e4\",\"...   \n",
       " 6   {\"userId\":\"1301025237bf5d4cb897def348b5c34d\",\"...   \n",
       " 7   {\"userId\":\"851acc5114efb01c289c7d0a7413ef16\",\"...   \n",
       " 8   {\"userId\":\"4bab60635f81a4c6bc8ad939fafd42fa\",\"...   \n",
       " 9   {\"userId\":\"ebc1ac8cd110b192221ec5643d908992\",\"...   \n",
       " 10  {\"userId\":\"76dfdc26df5b1dbf867e9771039805d5\",\"...   \n",
       " 11  {\"userId\":\"c80fa58afd445be3f1e693c8c14b81b0\",\"...   \n",
       " 12  {\"userId\":\"333eb61506b8c3ca34b15a31694f5f3f\",\"...   \n",
       " 13  {\"userId\":\"e78bac812788a0a8434abc0f72665183\",\"...   \n",
       " 14  {\"userId\":\"0cff1fd23e32146f53cc5925e8a25fcd\",\"...   \n",
       " 15  {\"userId\":\"5b1da3e0a03d93e10232217731f14fc5\",\"...   \n",
       " 16  {\"userId\":\"da11af1ff2714f74246995b3c384d002\",\"...   \n",
       " 17  {\"userId\":\"ec655e459ada13649fa242c47f3b0bc9\",\"...   \n",
       " 18  {\"userId\":\"01846acf99988cf68c4929cbbd38fae3\",\"...   \n",
       " 19  {\"userId\":\"d5461c6fa3451d72c14199fdaf1e8877\",\"...   \n",
       " 20  {\"userId\":\"b20a58ff47cb6e75d36c46ce847fb9a7\",\"...   \n",
       " 21  {\"userId\":\"1e30b3e17e614ff41ebd21406d31ae9e\",\"...   \n",
       " 22  {\"userId\":\"6d93023197629e19ffc1f5dab6b00ee2\",\"...   \n",
       " 23  {\"userId\":\"8b579aa0f4035f883c1e461855d92fda\",\"...   \n",
       " 24  {\"userId\":\"9f1becd64b9084dd64d762fd6a0b1e55\",\"...   \n",
       " 25  {\"userId\":\"106c67cd12a5ccdc852cd8d698115f1e\",\"...   \n",
       " 26  {\"userId\":\"d8e5cb3370b64f6220792f24d197a052\",\"...   \n",
       " 27  {\"userId\":\"25458b72214c3ac6779cb65a2fe23827\",\"...   \n",
       " 28  {\"userId\":\"0876c0f04a2458cf50d6baad8405b7e0\",\"...   \n",
       " 29  {\"userId\":\"e1539be94fb80f868a8882bacd893a1e\",\"...   \n",
       " 30  {\"userId\":\"aa24165bbabfcca80345e2f952585c0c\",\"...   \n",
       " 31  {\"userId\":\"d98df45648d75cf4ec38be2c36fc8e98\",\"...   \n",
       " 32  {\"userId\":\"7ae86c3dfbd3e609576943e00a3a4bae\",\"...   \n",
       " 33  {\"userId\":\"f92fb3345d24194fbfb6a0ad90900992\",\"...   \n",
       " 34  {\"userId\":\"6426e925206ea429a6046a0f31cfcb11\",\"...   \n",
       " 35  {\"userId\":\"c5a9c5515ad5186ba745573d2d16698e\",\"...   \n",
       " 36  {\"userId\":\"368de93d20e1a0fb2fc51e8ed83d2096\",\"...   \n",
       " 37  {\"userId\":\"16f89e6e35c5eab6884af735891d5deb\",\"...   \n",
       " 38  {\"userId\":\"4a37cb257c0703c0ef0983bc7142c697\",\"...   \n",
       " 39  {\"userId\":\"f75662a4aeb1d024e964c6178bbe5c73\",\"...   \n",
       " \n",
       "                                            job.labels  job.salary  job.dq  \\\n",
       " 0   [活动策划, 新媒体平台, 数据分析, 用户运营, 网络推广, 短视频运营, 品牌运营, 广...  15-20k·13薪      广州   \n",
       " 1                                             [新媒体运营]      15-20k  广州-天河区   \n",
       " 2   [用户运营, 平台运营, 新媒体运营, 新媒体平台, 产品运营, 电商运营, 社区运营, 汽...  12-20k·13薪      广州   \n",
       " 3   [新媒体运营, 平台运营, 网站运营, 短视频运营, 广告投放/流量运营, 产品运营, 网店...        6-8k      广州   \n",
       " 4        [新媒体运营, 策略运营, 平台运营, 新闻类, 市场运营, 新媒体平台, 自媒体平台]       8-15k  广州-番禺区   \n",
       " 5   [新媒体运营, 文案, 网络营销, 营销策划, 市场策划, 市场推广, 社群运营, 内容运营...       8-10k  广州-番禺区   \n",
       " 6                                  [kol, 内容运营, 新媒体运营]    6-8k·13薪  广州-越秀区   \n",
       " 7                                             [新媒体运营]        5-7k      广州   \n",
       " 8                           [内容运营, 新媒体平台, 新媒体运营, 大健康]      15-25k  广州-天河区   \n",
       " 9                                                  []       6-12k  广州-海珠区   \n",
       " 10                                      [营销策划, 新媒体运营]   6-10k·13薪  广州-海珠区   \n",
       " 11  [产品运营, 平台运营, 策划运营, 内容活动运营, 互联网大党建, 互联网+央企内宣, 项...       9-15k  广州-黄埔区   \n",
       " 12          [新媒体运营, 自媒体运营, 策略运营, 新媒体广告, 自媒体平台, 新媒体平台]      10-15k  广州-番禺区   \n",
       " 13                                            [新媒体运营]        4-7k  广州-天河区   \n",
       " 14                          [新媒体运营, 策略运营, 数据分析, 活动策划]        6-8k  广州-番禺区   \n",
       " 15                         [新媒体运营, 平台运营, 短视频运营, 抖音平台]   7-12k·13薪  广州-番禺区   \n",
       " 16             [电子商务, 新媒体运营, 内容运营, 活动策划, 用户运营, 新媒体平台]      15-20k      广州   \n",
       " 17  [新媒体运营, 粉丝运营, 内容运营, 自媒体运营, 用户运营, 电子商务, 自媒体平台, ...      12-23k  广州-天河区   \n",
       " 18                                 [策略运营, 数据运营, 社交平台]        6-8k  广州-番禺区   \n",
       " 19                                [新媒体运营, 用户运营, 粉丝运营]      10-18k      广州   \n",
       " 20  [用户运营, 活动策划, 新媒体运营, 平台运营, 内容运营, 自媒体运营, 短视频运营, ...       8-13k      广州   \n",
       " 21                            [媒介, 抖音快手, 新媒体运营, 网络营销]      30-50k  广州-白云区   \n",
       " 22       [新媒体运营, 视频类, 自媒体运营, 粉丝运营, 产品运营, 活动运营, 新媒体平台]      12-18k  广州-黄埔区   \n",
       " 23  [用户运营, 活动策划, 社群运营, 新媒体运营, 平台运营, 新媒体平台, 网络推广, 自...       8-10k  广州-增城区   \n",
       " 24  [用户运营, 自媒体平台, 新媒体运营, 产品运营, 自媒体运营, 电子商务, 生活类, 线...        6-9k      广州   \n",
       " 25                                            [新媒体运营]      20-30k      广州   \n",
       " 26  [活动运营, 自媒体运营, 新媒体运营, 运营规划, 运营推广, 引流拉新, 用户促活, 用...   5-10k·13薪      广州   \n",
       " 27                                            [新媒体运营]      10-15k      广州   \n",
       " 28          [新媒体运营, 社群运营, 市场策划, 内容运营, 文案, 营销策划, 市场推广]      18-22k      广州   \n",
       " 29                                            [新媒体运营]       6-11k  广州-白云区   \n",
       " 30                                         [抖音、小红书运营]        6-9k  广州-白云区   \n",
       " 31                                            [新媒体运营]   8-10k·13薪      广州   \n",
       " 32                                            [新媒体运营]       7-10k      广州   \n",
       " 33  [小红书平台, 新媒体运营, 自媒体平台, 新媒体平台, 平台运营, 内容运营, 活动运营,...        4-9k      广州   \n",
       " 34                                            [新媒体运营]        4-6k      广州   \n",
       " 35                          [新媒体运营, 视频类, 平台运营, 新媒体平台]      10-15k  广州-白云区   \n",
       " 36  [视频类, 新媒体运营, 品牌运营, 网络推广, 内容运营, 渠道运营, 新媒体平台, 线上...       6-18k  广州-黄埔区   \n",
       " 37                       [新媒体运营, 小红书平台, 抖音 运营, 公众号运营]        5-7k  广州-番禺区   \n",
       " 38                                            [新媒体运营]   6-10k·14薪      广州   \n",
       " 39                                            [新媒体运营]       8-15k  广州-白云区   \n",
       " \n",
       "    job.requireWorkYears job.refreshTime job.jobId job.jobKind  job.topJob  \\\n",
       " 0                 5-10年  20220510093710  47155821           2       False   \n",
       " 1                  3-5年  20210309161349  35666959           2       False   \n",
       " 2                  3-5年  20230316193149  52794689           2       False   \n",
       " 3                  1-3年  20220815162635  49068371           2       False   \n",
       " 4                  1-3年  20211102105032  42218367           2       False   \n",
       " 5                  3-5年  20200630160629  29526339           2       False   \n",
       " 6                  1-3年  20211020172014  44123093           2       False   \n",
       " 7                  一年以下  20210818091848  42282877           2       False   \n",
       " 8                 5-10年  20230602095751  58585097           2       False   \n",
       " 9                  经验不限  20220906162529  52420901           2       False   \n",
       " 10                 1-3年  20211011162507  43842953           2       False   \n",
       " 11                5-10年  20221229120950  55203933           2       False   \n",
       " 12                 3-5年  20230511172850  58489463           2       False   \n",
       " 13                 经验不限  20210907172914  42983423           2       False   \n",
       " 14                 1-3年  20230523153516  58776921           2       False   \n",
       " 15                 1-3年  20230323153304  56676897           2       False   \n",
       " 16                 3-5年  20221222141619  47745131           2       False   \n",
       " 17                 3-5年  20230327175627  55137595           2       False   \n",
       " 18                 1-3年  20230606160844  58880029           2       False   \n",
       " 19                 1-3年  20230607142340  59153161           2       False   \n",
       " 20                 3-5年  20230609161057  55064403           2       False   \n",
       " 21                5-10年  20230612092712  44754841           1       False   \n",
       " 22                 3-5年  20220902163654  52353605           2       False   \n",
       " 23                 3-5年  20230320114749  56397451           2       False   \n",
       " 24                 3-5年  20230404213154  57553357           2       False   \n",
       " 25                 经验不限  20210421203650  38436857           2       False   \n",
       " 26                 经验不限  20220803160651  46543489           2       False   \n",
       " 27                 经验不限  20210328214122  37343851           2       False   \n",
       " 28                 3-5年  20210321214806  37309923           2       False   \n",
       " 29                 经验不限  20200611160153  29119859           2       False   \n",
       " 30                 1-3年  20220112102915  42549189           2       False   \n",
       " 31                 经验不限  20220109133609  44893243           2       False   \n",
       " 32                 1-3年  20210716105518  41119495           2       False   \n",
       " 33                 1-3年  20220826080346  52107329           2       False   \n",
       " 34                 经验不限  20211215203500  45716327           2       False   \n",
       " 35                 3-5年  20221201174348  53350573           2       False   \n",
       " 36                 1-3年  20221214151146  54822761           2       False   \n",
       " 37                 1-3年  20221204105528  54859461           2       False   \n",
       " 38                 1-3年  20200923202110  31688867           2       False   \n",
       " 39                 1-3年  20210518152500  39256961           2       False   \n",
       " \n",
       "     ...  recruiter.recruiterName recruiter.recruiterTitle  \\\n",
       " 0   ...                      杜先生                            \n",
       " 1   ...                      赖女士                       人事   \n",
       " 2   ...                      李先生               hrbp（信息中心）   \n",
       " 3   ...                      黄女士                       HR   \n",
       " 4   ...                      赵先生                  创始人兼CEO   \n",
       " 5   ...                      黎女士                     行政总监   \n",
       " 6   ...                      秦女士                     招聘专员   \n",
       " 7   ...                      冯先生                     产品经理   \n",
       " 8   ...                      秦先生                人力资源总监HRD   \n",
       " 9   ...                      郭女士                       人事   \n",
       " 10  ...                      杨女士                     行政经理   \n",
       " 11  ...                      宋女士                   人力资源专员   \n",
       " 12  ...                      杨女士                  招聘专员/助理   \n",
       " 13  ...                      彭女士                   运营部负责人   \n",
       " 14  ...                      罗女士                            \n",
       " 15  ...                      吴女士                 助理顾问(AC)   \n",
       " 16  ...                      郑先生                            \n",
       " 17  ...                      黄女士                 高级人力行政经理   \n",
       " 18  ...                      罗女士                   人力资源专员   \n",
       " 19  ...                      陈先生                            \n",
       " 20  ...                      黄先生                       经理   \n",
       " 21  ...                      江先生                     猎头顾问   \n",
       " 22  ...                      张女士                            \n",
       " 23  ...                      于先生                  行政、人力资源   \n",
       " 24  ...                      常先生                     人事主管   \n",
       " 25  ...                      徐女士                人力资源经理/主管   \n",
       " 26  ...                      郑先生                       HR   \n",
       " 27  ...                      邓先生                     运营经理   \n",
       " 28  ...                      孙先生                      创始人   \n",
       " 29  ...                      肖先生                      董事长   \n",
       " 30  ...                      程女士                       行政   \n",
       " 31  ...                      沈先生                  美容皮肤科医生   \n",
       " 32  ...                      黎先生                     选聘经理   \n",
       " 33  ...                      卿先生                    机构负责人   \n",
       " 34  ...                      陈先生                     boss   \n",
       " 35  ...                      蔡女士                            \n",
       " 36  ...                      冯女士                     人事专员   \n",
       " 37  ...                      刘女士                   人事行政专员   \n",
       " 38  ...                      唐女士                            \n",
       " 39  ...                      冯女士                     人事主管   \n",
       " \n",
       "            recruiter.recruiterPhoto comp.compId comp.compScale  \\\n",
       " 0   5f8f98698dbe6273dcf8516008u.jpg  12425331.0         50-99人   \n",
       " 1   5f8f986779c7cc70efbf36c008u.jpg  12533401.0         50-99人   \n",
       " 2   556f335a0cf2261962eceaca02c.jpg    466790.0    5000-10000人   \n",
       " 3   5f8f9866dfb13a7dee342f1808u.jpg   8691504.0          1-49人   \n",
       " 4   6118df999920a53a8b86f4c701u.png  12888027.0          1-49人   \n",
       " 5   5f8f9863f6d1ab58476f246a08u.jpg  10244097.0                  \n",
       " 6   5f8f9866dfb13a7dee342f1808u.jpg  12829263.0          1-49人   \n",
       " 7   5f8f986aea60860b75384fab08u.jpg  12878183.0          1-49人   \n",
       " 8   5f8f986bdfb13a7dee342f2108u.jpg  10080727.0       100-499人   \n",
       " 9   5f8f9866dfb13a7dee342f1808u.jpg  13309587.0         50-99人   \n",
       " 10  5f8f9866dfb13a7dee342f1808u.jpg  12963119.0       100-499人   \n",
       " 11  5f8f986779c7cc70efbf36c008u.jpg   2306626.0         50-99人   \n",
       " 12  5f8f9865ea60860b75384fa508u.jpg  12549385.0       100-499人   \n",
       " 13  61403e8514986c5f4de0059e05u.png  12274475.0          1-49人   \n",
       " 14  5f8f9865ea60860b75384fa508u.jpg   9140378.0       500-999人   \n",
       " 15  5f8f98648dbe6273dcf8515508u.jpg  13438197.0         50-99人   \n",
       " 16  5f8f986779c7cc70efbf36c008u.jpg   8014859.0       500-999人   \n",
       " 17  5f8f9865ea60860b75384fa508u.jpg  13344155.0                  \n",
       " 18  5f8f986779c7cc70efbf36c008u.jpg   9140378.0       500-999人   \n",
       " 19  5f8f986bdfb13a7dee342f2108u.jpg   9410046.0       100-499人   \n",
       " 20  5f8f986c79c7cc70efbf36c808u.jpg  13355209.0          1-49人   \n",
       " 21  62621072a922046ee613528003u.png         NaN       500-999人   \n",
       " 22  5f8f9866dfb13a7dee342f1808u.jpg   6994418.0       500-999人   \n",
       " 23  5f8f98698dbe6273dcf8516008u.jpg  13432769.0       100-499人   \n",
       " 24  5f8f986bdfb13a7dee342f2108u.jpg  13059041.0                  \n",
       " 25  606168a404dcde72385b01d902u.png  12704593.0          1-49人   \n",
       " 26  5f8f986aea60860b75384fab08u.jpg  13007319.0         50-99人   \n",
       " 27  6060902841d68823662c7c6006u.png  10259381.0       100-499人   \n",
       " 28  604f5cef587acf01b4196c6a06u.png  12634153.0          1-49人   \n",
       " 29  5f8f98698dbe6273dcf8516008u.jpg  12274307.0          1-49人   \n",
       " 30  5f8f98648dbe6273dcf8515508u.jpg  12903341.0         50-99人   \n",
       " 31  5f8f986bdfb13a7dee342f2108u.jpg  12964059.0         50-99人   \n",
       " 32  5f1719d6f3eec46a324f890703u.png   9107392.0       10000人以上   \n",
       " 33  6348dede41b85513c68fe39e07u.png  12461519.0          1-49人   \n",
       " 34  5f8f986aea60860b75384fab08u.jpg  13033031.0         50-99人   \n",
       " 35  5f8f9866dfb13a7dee342f1808u.jpg  13213295.0          1-49人   \n",
       " 36  5f8f9863f6d1ab58476f246a08u.jpg  13367829.0         50-99人   \n",
       " 37  6242bafa02ce8915f744c82c07u.png  13174295.0         50-99人   \n",
       " 38  5f8f9866dfb13a7dee342f1808u.jpg    883294.0       500-999人   \n",
       " 39  5f8f98648dbe6273dcf8515508u.jpg  12748465.0          1-49人   \n",
       " \n",
       "        comp.compName                    comp.compLogo  \\\n",
       " 0      广州菲尔曼生物科技有限公司  607ea00d961ca61cd237dd1008u.png   \n",
       " 1         广州军道科技有限公司  60094840f02f27232268191c07u.jpg   \n",
       " 2               华胜集团  5bfe8f3c74719d35745a663203a.png   \n",
       " 3       广州聚超软件科技有限公司  5bfe9ea774719d2aa34b9df703a.png   \n",
       " 4             创商教育集团  61b07937d0458d53c627567e02u.jpg   \n",
       " 5     君康生物科技(广州)有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 6     广州宠小到大智能科技有限公司  614d717bd66f890bba11c7a503u.jpg   \n",
       " 7      广州莉微娜生物科技有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 8    广东壹加再生医学研究院有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 9    广州优智保智能环保科技有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 10  幸福有方(广州)咨询服务有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 11              知微科技  5c77869d261c45f04795a04705u.jpg   \n",
       " 12             轻微课教育  60506adf70774c5aab5ef47b04u.png   \n",
       " 13      广州墨鱼教育科技有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 14   广州市泰迪熊婴幼儿用品有限公司  60a34d6680c1184641e5c75e03u.png   \n",
       " 15     深圳市润美文化传媒有限公司  619d02d81bd4fb704e49b1f005u.jpg   \n",
       " 16               杰凡尼  5bfea42274719d2aa34cab1203a.png   \n",
       " 17         木棉花生殖专科连锁  63748ea93d0eea5b6c4a226803u.png   \n",
       " 18   广州市泰迪熊婴幼儿用品有限公司  60a34d6680c1184641e5c75e03u.png   \n",
       " 19      广州炫动信息科技有限公司  62eb2cff7f2ae41acfa6264501u.png   \n",
       " 20              好融科技  642a7993f8732420a17138ae04u.jpg   \n",
       " 21             某知名公司  60e2fe0bf3df194a3c48adb502u.png   \n",
       " 22               康耐登  54d1ea03712eb4f6b84d44c202c.png   \n",
       " 23        广州盛博家居有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 24    常青学车服务(广州)有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 25    广州华玺教育科技发展有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 26      瑞浩能源(广东)有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 27              致学教育  60a4747ad2c6470a6cd6e33001u.png   \n",
       " 28              诺氧健康  605740963219a274a6c08bff07u.jpg   \n",
       " 29   广州市全酋通物流供应链有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 30     广州英凡妮生物科技有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 31   广州伊羡医疗美容门诊部有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 32      广州晓晓传播科技有限公司  5bfe9b2074719df0ac99f5fc03a.png   \n",
       " 33     广州叁人行教育科技有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 34    广州大题小做教育咨询有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 35       广州深寰宇酒业有限公司  62a82e710879ad1a2ab7b20b05u.png   \n",
       " 36   广州市显浩医疗设备股份有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 37  广州市一亩三分地农业发展有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " 38             太平洋网络  5bfe91bf74719d35745ae43f03a.png   \n",
       " 39        广州铂芯科技有限公司  61b07937d0458d53c627567e02u.jpg   \n",
       " \n",
       "                                    comp.link comp.compIndustry comp.compStage  \n",
       " 0   https://www.liepin.com/company/12425331/                日化            NaN  \n",
       " 1   https://www.liepin.com/company/12533401/               互联网            天使轮  \n",
       " 2     https://www.liepin.com/company/466790/          汽车交易/后市场            NaN  \n",
       " 3    https://www.liepin.com/company/8691504/             计算机软件          融资未公开  \n",
       " 4   https://www.liepin.com/company/12888027/              培训服务             A轮  \n",
       " 5   https://www.liepin.com/company/10244097/              培训服务          融资未公开  \n",
       " 6   https://www.liepin.com/company/12829263/              电子商务             其他  \n",
       " 7   https://www.liepin.com/company/12878183/              电子商务            NaN  \n",
       " 8   https://www.liepin.com/company/10080727/                制药          融资未公开  \n",
       " 9   https://www.liepin.com/company/13309587/            专业技术服务            NaN  \n",
       " 10  https://www.liepin.com/company/12963119/            专业技术服务            NaN  \n",
       " 11   https://www.liepin.com/company/2306626/               互联网             A轮  \n",
       " 12  https://www.liepin.com/company/12549385/              培训服务           战略投资  \n",
       " 13  https://www.liepin.com/company/12274475/          广播/影视/录音            NaN  \n",
       " 14   https://www.liepin.com/company/9140378/             批发/零售          融资未公开  \n",
       " 15  https://www.liepin.com/company/13438197/          广告/公关/会展            NaN  \n",
       " 16   https://www.liepin.com/company/8014859/          服装/纺织/皮革            NaN  \n",
       " 17  https://www.liepin.com/company/13344155/              医疗机构            NaN  \n",
       " 18   https://www.liepin.com/company/9140378/             批发/零售          融资未公开  \n",
       " 19   https://www.liepin.com/company/9410046/                游戏           战略投资  \n",
       " 20  https://www.liepin.com/company/13355209/              IT服务            NaN  \n",
       " 21                                                        电子商务          融资未公开  \n",
       " 22   https://www.liepin.com/company/6994418/             家具/家居            NaN  \n",
       " 23  https://www.liepin.com/company/13432769/             家具/家居            NaN  \n",
       " 24  https://www.liepin.com/company/13059041/            专业技术服务            NaN  \n",
       " 25  https://www.liepin.com/company/12704593/            专业技术服务            NaN  \n",
       " 26  https://www.liepin.com/company/13007319/            专业技术服务            NaN  \n",
       " 27  https://www.liepin.com/company/10259381/              在线教育            NaN  \n",
       " 28  https://www.liepin.com/company/12634153/          食品/饮料/酒水            天使轮  \n",
       " 29  https://www.liepin.com/company/12274307/          货运/物流/仓储          融资未公开  \n",
       " 30  https://www.liepin.com/company/12903341/            专业技术服务            NaN  \n",
       " 31  https://www.liepin.com/company/12964059/          美容/美发/保健            NaN  \n",
       " 32   https://www.liepin.com/company/9107392/              培训服务          融资未公开  \n",
       " 33  https://www.liepin.com/company/12461519/            专业技术服务            NaN  \n",
       " 34  https://www.liepin.com/company/13033031/            专业技术服务            NaN  \n",
       " 35  https://www.liepin.com/company/13213295/            贸易/进出口            NaN  \n",
       " 36  https://www.liepin.com/company/13367829/              医疗器械          融资未公开  \n",
       " 37  https://www.liepin.com/company/13174295/           农/林/牧/渔            NaN  \n",
       " 38    https://www.liepin.com/company/883294/               互联网            已上市  \n",
       " 39  https://www.liepin.com/company/12748465/              其他行业            NaN  \n",
       " \n",
       " [40 rows x 31 columns],\n",
       "                                              dataInfo  \\\n",
       " 0   %7B%22jobId%22%3A%2259262095%22%2C%22scene%22%...   \n",
       " 1   %7B%22jobId%22%3A%2258182769%22%2C%22scene%22%...   \n",
       " 2   %7B%22jobId%22%3A%2255847875%22%2C%22scene%22%...   \n",
       " 3   %7B%22jobId%22%3A%2256607691%22%2C%22scene%22%...   \n",
       " 4   %7B%22jobId%22%3A%2244622165%22%2C%22scene%22%...   \n",
       " 5   %7B%22jobId%22%3A%2255795801%22%2C%22scene%22%...   \n",
       " 6   %7B%22jobId%22%3A%2251204113%22%2C%22scene%22%...   \n",
       " 7   %7B%22jobId%22%3A%2240373051%22%2C%22scene%22%...   \n",
       " 8   %7B%22jobId%22%3A%2241094851%22%2C%22scene%22%...   \n",
       " 9   %7B%22jobId%22%3A%2255799651%22%2C%22scene%22%...   \n",
       " 10  %7B%22jobId%22%3A%2252927495%22%2C%22scene%22%...   \n",
       " 11  %7B%22jobId%22%3A%2256900867%22%2C%22scene%22%...   \n",
       " 12  %7B%22jobId%22%3A%2256120831%22%2C%22scene%22%...   \n",
       " 13  %7B%22jobId%22%3A%2244469011%22%2C%22scene%22%...   \n",
       " 14  %7B%22jobId%22%3A%2242532811%22%2C%22scene%22%...   \n",
       " 15  %7B%22jobId%22%3A%2256060331%22%2C%22scene%22%...   \n",
       " 16  %7B%22jobId%22%3A%2244794187%22%2C%22scene%22%...   \n",
       " 17  %7B%22jobId%22%3A%2244089837%22%2C%22scene%22%...   \n",
       " 18  %7B%22jobId%22%3A%2243510727%22%2C%22scene%22%...   \n",
       " 19  %7B%22jobId%22%3A%2252274337%22%2C%22scene%22%...   \n",
       " 20  %7B%22jobId%22%3A%2256873001%22%2C%22scene%22%...   \n",
       " 21  %7B%22jobId%22%3A%2259127263%22%2C%22scene%22%...   \n",
       " 22  %7B%22jobId%22%3A%2257679469%22%2C%22scene%22%...   \n",
       " 23  %7B%22jobId%22%3A%2240170349%22%2C%22scene%22%...   \n",
       " 24  %7B%22jobId%22%3A%2246354497%22%2C%22scene%22%...   \n",
       " 25  %7B%22jobId%22%3A%2247397357%22%2C%22scene%22%...   \n",
       " 26  %7B%22jobId%22%3A%2239558261%22%2C%22scene%22%...   \n",
       " 27  %7B%22jobId%22%3A%2218141229%22%2C%22scene%22%...   \n",
       " 28  %7B%22jobId%22%3A%2255630469%22%2C%22scene%22%...   \n",
       " 29  %7B%22jobId%22%3A%2246808191%22%2C%22scene%22%...   \n",
       " 30  %7B%22jobId%22%3A%2229179823%22%2C%22scene%22%...   \n",
       " 31  %7B%22jobId%22%3A%2256733667%22%2C%22scene%22%...   \n",
       " 32  %7B%22jobId%22%3A%2251449655%22%2C%22scene%22%...   \n",
       " 33  %7B%22jobId%22%3A%2236518843%22%2C%22scene%22%...   \n",
       " 34  %7B%22jobId%22%3A%2240932831%22%2C%22scene%22%...   \n",
       " 35  %7B%22jobId%22%3A%2246558817%22%2C%22scene%22%...   \n",
       " 36  %7B%22jobId%22%3A%2250257385%22%2C%22scene%22%...   \n",
       " 37  %7B%22jobId%22%3A%2237495167%22%2C%22scene%22%...   \n",
       " 38  %7B%22jobId%22%3A%2242695597%22%2C%22scene%22%...   \n",
       " 39  %7B%22jobId%22%3A%2241783453%22%2C%22scene%22%...   \n",
       " \n",
       "                                            dataParams  \\\n",
       " 0   {\"userId\":\"5b6fbbe44ca17c7da983bffaf99d1320\",\"...   \n",
       " 1   {\"userId\":\"320031bc67a2109fb0cf7babe7174c0e\",\"...   \n",
       " 2   {\"userId\":\"8293a2d392d35e8caf7df25d3e1d2a19\",\"...   \n",
       " 3   {\"userId\":\"6c6f8e3bfbb5e2c0223e3bd7760326b6\",\"...   \n",
       " 4   {\"userId\":\"08f15b5e8fd75dad97545e8f3fbf2c87\",\"...   \n",
       " 5   {\"userId\":\"135f083422b51ffde9a4ac41f1417c7b\",\"...   \n",
       " 6   {\"userId\":\"a0fef7e371b4331aafb674a127b4f704\",\"...   \n",
       " 7   {\"userId\":\"2088531216e87709c4cdd5fbc62a3817\",\"...   \n",
       " 8   {\"userId\":\"6245cff9a0ec41a5fd6e2fbf637db1a6\",\"...   \n",
       " 9   {\"userId\":\"c8c8de08349203b012bb2302cdb4827a\",\"...   \n",
       " 10  {\"userId\":\"b1284ebeaa217883c095306692726b2a\",\"...   \n",
       " 11  {\"userId\":\"e036b40d52c117320193ae1deef880a5\",\"...   \n",
       " 12  {\"userId\":\"a7470fcae63e1ef8484f7e35a9b8c987\",\"...   \n",
       " 13  {\"userId\":\"b6639f8adbf7886312b86ce8461f75b9\",\"...   \n",
       " 14  {\"userId\":\"43590c9794d7732731ab7afaa41986d5\",\"...   \n",
       " 15  {\"userId\":\"e21f56fac74a59568777878acd99f189\",\"...   \n",
       " 16  {\"userId\":\"1bc9cb0869d3c49b08b3c40ed22d10f2\",\"...   \n",
       " 17  {\"userId\":\"e87dd7a275069739ab1f0b45b24a43bd\",\"...   \n",
       " 18  {\"userId\":\"d0d897f8a8621069c6fb05b14579a97f\",\"...   \n",
       " 19  {\"userId\":\"2cbf6b2c611eab819a79488f72cc998c\",\"...   \n",
       " 20  {\"userId\":\"d5236ad0db4e40141fcdbb2c3974737d\",\"...   \n",
       " 21  {\"userId\":\"f1052fcc81d3c2335e736c601a9ce071\",\"...   \n",
       " 22  {\"userId\":\"c04f85ceacc1217b5a003428087e62e2\",\"...   \n",
       " 23  {\"userId\":\"e2bacc53cb71507499c83f44575cb14a\",\"...   \n",
       " 24  {\"userId\":\"9f23a9912d0ec54ad26b0dceaf627918\",\"...   \n",
       " 25  {\"userId\":\"c8656e9ffe4104e2987f7a9d310c7df4\",\"...   \n",
       " 26  {\"userId\":\"c84fdbca222cd4e4abff1dfd0ece16e2\",\"...   \n",
       " 27  {\"userId\":\"3371aab1da7b11ee313f2ceec13be5c3\",\"...   \n",
       " 28  {\"userId\":\"a6497094b7babb44102cd7321dca3526\",\"...   \n",
       " 29  {\"userId\":\"d6f4eaf9e8558c295673c93fe8af5efb\",\"...   \n",
       " 30  {\"userId\":\"72f5a27210c71d32f5407cfd825f86a4\",\"...   \n",
       " 31  {\"userId\":\"49f425d89e58263262a4d84e0af55f9a\",\"...   \n",
       " 32  {\"userId\":\"cfbd355fd16026c369dca8db230a680f\",\"...   \n",
       " 33  {\"userId\":\"deaa5be521bde1c0fd0bb6141bcd879c\",\"...   \n",
       " 34  {\"userId\":\"7a08a50e7cb0cedc7a6177a014e20d4a\",\"...   \n",
       " 35  {\"userId\":\"a4fadcf00aed55b828866d218ef586d8\",\"...   \n",
       " 36  {\"userId\":\"b36f95e567e6755d28a7a2a16782569c\",\"...   \n",
       " 37  {\"userId\":\"ba5752fb55ea9562e09ac4eb9df5c65e\",\"...   \n",
       " 38  {\"userId\":\"13887b71c9311edf66e3fe8f1091b174\",\"...   \n",
       " 39  {\"userId\":\"3539f39bbf4bb962c6f31a942edcd724\",\"...   \n",
       " \n",
       "                                            job.labels job.jobId  \\\n",
       " 0                                             [新媒体运营]  59262095   \n",
       " 1                                       [新媒体运营, 社群运营]  58182769   \n",
       " 2                                 [新媒体运营, 内容运营, 电子商务]  55847875   \n",
       " 3                     [数据分析, 平台运营, 数据运营, 新媒体运营, 知乎平台]  56607691   \n",
       " 4                     [平台运营, 数据运营, 新媒体运营, 数据分析, 知乎平台]  44622165   \n",
       " 5   [新媒体运营, 数据运营, 电商运营, 平台运营, 数据分析, 电子商务, 知乎平台, 新媒...  55795801   \n",
       " 6   [新媒体运营, 品牌运营, 新闻类, 自媒体运营, 平台运营, 活动策划, IT/互联网/软...  51204113   \n",
       " 7                                       [内容运营, 新媒体运营]  40373051   \n",
       " 8                                             [新媒体运营]  41094851   \n",
       " 9        [新媒体运营, 自媒体运营, 内容运营, 品牌运营, 活动策划, 电子商务, 电商平台]  55799651   \n",
       " 10                          [自媒体运营, 新媒体运营, 新闻类, 直播平台]  52927495   \n",
       " 11  [新媒体运营, 数据运营, 广告投放/流量运营, 策略运营, 自媒体运营, 内容运营, 信息...  56900867   \n",
       " 12  [新媒体运营, 策略运营, 新媒体平台, 自媒体运营, 短视频运营, 粉丝运营, 消费品, ...  56120831   \n",
       " 13  [数据运营, 新媒体运营, 广告投放/流量运营, 信息流投放, 自媒体运营, 内容运营, 策...  44469011   \n",
       " 14               [文案, 渠道运营, 内容运营, 新媒体运营, 小红书运营, B站运营]  42532811   \n",
       " 15             [新媒体运营, 平台运营, 粉丝运营, 策略运营, 线上运营, 新媒体平台]  56060331   \n",
       " 16  [新媒体运营, 数据运营, 广告投放/流量运营, 内容运营, 自媒体运营, 策略运营, 信息...  44794187   \n",
       " 17                                        [文案, 新媒体运营]  44089837   \n",
       " 18                                            [新媒体运营]  43510727   \n",
       " 19  [新媒体运营, 粉丝运营, 品牌运营, IT/互联网/软件, 新媒体平台, 线下运营, 自媒...  52274337   \n",
       " 20                   [内容运营, 自媒体运营, 新媒体运营, 线上运营, 线下运营]  56873001   \n",
       " 21                                [新媒体运营, 策略运营, 社交平台]  59127263   \n",
       " 22  [广告投放/流量运营, 自媒体运营, 活动运营, 策略运营, 短视频运营, 网络推广, 粉丝...  57679469   \n",
       " 23                                            [新媒体运营]  40170349   \n",
       " 24  [新媒体运营, 运营管理, 策略运营, 平台运营, 内容运营, 线上运营, to B, 运营...  46354497   \n",
       " 25  [活动运营, 自媒体运营, 新媒体运营, 运营规划, 运营推广, 引流拉新, 用户促活, 用...  47397357   \n",
       " 26                                            [新媒体运营]  39558261   \n",
       " 27                  [新媒体运营, 自媒体运营, 用户运营, 新媒体平台, 抖音平台]  18141229   \n",
       " 28  [用户运营, 渠道推广, 内容运营, 社群运营, 网络推广, 渠道运营, 活动运营, 微博平...  55630469   \n",
       " 29  [市场营销, 市场拓展, 市场策划, 效果评估, 渠道推广, 市场推广, 活动策划, KOL...  46808191   \n",
       " 30                                        [软文, 新媒体运营]  29179823   \n",
       " 31                 [内容运营, 新媒体运营, 微信公众号, 广告公司, 4A公司背景]  56733667   \n",
       " 32  [新媒体运营, 市场运营, 活动运营, 内容运营, 教育培训, 线上运营, 线下运营, 微信...  51449655   \n",
       " 33                 [kol, 裂变, 拉新, 引流, 转化, 用户运营, 教育新媒体]  36518843   \n",
       " 34                                            [新媒体运营]  40932831   \n",
       " 35            [新媒体, 品牌策划, 营销推广, 冥想, 身心健康, 社交媒体, 心理健康]  46558817   \n",
       " 36               [新媒体运营, 平台运营, 粉丝运营, 广告/传媒/文化, 新媒体平台]  50257385   \n",
       " 37   [文案, 新媒体运营, 社群运营, 广告创意, 内容运营, 渠道运营, 产品运营, 小程序运营]  37495167   \n",
       " 38                                            [新媒体运营]  42695597   \n",
       " 39                          [新媒体运营, 网络营销, 市场推广, 内容运营]  41783453   \n",
       " \n",
       "            job.title job.jobKind  job.topJob job.refreshTime  job.salary  \\\n",
       " 0            新媒体运营主管           2       False  20230612152743       8-12k   \n",
       " 1            新媒体运营经理           2       False  20230605094039      10-15k   \n",
       " 2            新媒体运营经理           2       False  20230301141954  20-25k·13薪   \n",
       " 3    新媒体运营经理（得物、小红书）           2       False  20230301170131  15-30k·13薪   \n",
       " 4            新媒体运营经理           1       False  20230322094652      28-35k   \n",
       " 5            新媒体运营经理           2       False  20230203163744      20-25k   \n",
       " 6              新媒体运营           2       False  20220718165035       5-10k   \n",
       " 7         新媒体运营经理/总监           2       False  20230307152401      10-20k   \n",
       " 8              新媒体运营           2       False  20210715153159       6-11k   \n",
       " 9     新媒体运营经理（护肤品公司）           2       False  20230602101031      13-16k   \n",
       " 10         新媒体运营（主播）           2       False  20221018102715      12-17k   \n",
       " 11           新媒体运营经理           2       False  20230612140542      15-25k   \n",
       " 12           新媒体运营经理           2       False  20230606184741  15-18k·13薪   \n",
       " 13           新媒体运营经理           1       False  20230316150908      15-25k   \n",
       " 14           新媒体运营经理           2       False  20230324102311      15-20k   \n",
       " 15           新媒体运营经理           2       False  20230612092327  12-15k·13薪   \n",
       " 16           新媒体运营经理           1       False  20230328105723  16-25k·13薪   \n",
       " 17  新媒体运营(抖音/快手/小红书)           2       False  20230504174026      10-20k   \n",
       " 18             新媒体运营           2       False  20230612101241       7-10k   \n",
       " 19           新媒体运营经理           2       False  20230223161825       6-10k   \n",
       " 20           资深新媒体运营           2       False  20230612125626       8-15k   \n",
       " 21             新媒体运营           2       False  20230606163933        5-6k   \n",
       " 22           新媒体运营主管           2       False  20230410222325        5-8k   \n",
       " 23           新媒体运营主管           2       False  20210616174054      12-18k   \n",
       " 24           新媒体运营总监           2       False  20220112145228      11-22k   \n",
       " 25           新媒体运营主管           2       False  20220726113117       5-10k   \n",
       " 26           新媒体运营专员           2       False  20220629140755    4-6k·13薪   \n",
       " 27           新媒体运营专员           2       False  20190502133214       5-10k   \n",
       " 28             新媒体运营           2       False  20230130161917        6-9k   \n",
       " 29    市场专员（新媒体运营及投放）           2       False  20220608155428        6-8k   \n",
       " 30           新媒体运营主管           2       False  20201104163745       8-13k   \n",
       " 31           新媒体运营经理           2       False  20230307144208      12-16k   \n",
       " 32        新媒体运营/市场专员           2       False  20220727155759       5-10k   \n",
       " 33           新媒体运营主管           2       False  20210303151613       7-10k   \n",
       " 34    新媒体运营经理&leader           2       False  20210711131553  15-30k·13薪   \n",
       " 35      品牌内容 & 新媒体运营           2       False  20220428164400       8-15k   \n",
       " 36           新媒体运营专员           2       False  20220901095908        5-8k   \n",
       " 37           新媒体运营主管           2       False  20210510103016       6-12k   \n",
       " 38       新媒体运营-外国语学校           2       False  20211215130615       7-10k   \n",
       " 39           新媒体运营专员           2       False  20210811093553        4-8k   \n",
       " \n",
       "     job.dq  ... recruiter.recruiterTitle             recruiter.recruiterId  \\\n",
       " 0   广州-天河区  ...                       人事  5b6fbbe44ca17c7da983bffaf99d1320   \n",
       " 1   广州-黄埔区  ...                       人事  320031bc67a2109fb0cf7babe7174c0e   \n",
       " 2   广州-白云区  ...                     hrbp  8293a2d392d35e8caf7df25d3e1d2a19   \n",
       " 3   广州-白云区  ...                     招聘HR  6c6f8e3bfbb5e2c0223e3bd7760326b6   \n",
       " 4   广州-白云区  ...                     猎头顾问  08f15b5e8fd75dad97545e8f3fbf2c87   \n",
       " 5   广州-白云区  ...                       HR  135f083422b51ffde9a4ac41f1417c7b   \n",
       " 6   广州-番禺区  ...                     区域经理  a0fef7e371b4331aafb674a127b4f704   \n",
       " 7   广州-黄埔区  ...                           2088531216e87709c4cdd5fbc62a3817   \n",
       " 8   广州-花都区  ...                       行政  6245cff9a0ec41a5fd6e2fbf637db1a6   \n",
       " 9   广州-白云区  ...                           c8c8de08349203b012bb2302cdb4827a   \n",
       " 10      广州  ...      广东教育出版社有限公司人力资源部副经理  b1284ebeaa217883c095306692726b2a   \n",
       " 11  广州-番禺区  ...                   招聘培训经理  e036b40d52c117320193ae1deef880a5   \n",
       " 12      广州  ...                       HR  a7470fcae63e1ef8484f7e35a9b8c987   \n",
       " 13  广州-番禺区  ...                     猎头顾问  b6639f8adbf7886312b86ce8461f75b9   \n",
       " 14  广州-天河区  ...                       经理  43590c9794d7732731ab7afaa41986d5   \n",
       " 15  广州-黄埔区  ...                   招聘培训经理  e21f56fac74a59568777878acd99f189   \n",
       " 16      广州  ...                     猎头顾问  1bc9cb0869d3c49b08b3c40ed22d10f2   \n",
       " 17      广州  ...                     行政总监  e87dd7a275069739ab1f0b45b24a43bd   \n",
       " 18  广州-天河区  ...                   人力资源经理  d0d897f8a8621069c6fb05b14579a97f   \n",
       " 19  广州-海珠区  ...                        一  2cbf6b2c611eab819a79488f72cc998c   \n",
       " 20  广州-增城区  ...                       HR  d5236ad0db4e40141fcdbb2c3974737d   \n",
       " 21  广州-天河区  ...                     行政主管  f1052fcc81d3c2335e736c601a9ce071   \n",
       " 22  广州-增城区  ...                      总经理  c04f85ceacc1217b5a003428087e62e2   \n",
       " 23      广州  ...                     hrbp  e2bacc53cb71507499c83f44575cb14a   \n",
       " 24  广州-白云区  ...                     行政总监  9f23a9912d0ec54ad26b0dceaf627918   \n",
       " 25  广州-番禺区  ...                     人事经理  c8656e9ffe4104e2987f7a9d310c7df4   \n",
       " 26      广州  ...                       HR  c84fdbca222cd4e4abff1dfd0ece16e2   \n",
       " 27  广州-南沙区  ...                      总经理  3371aab1da7b11ee313f2ceec13be5c3   \n",
       " 28  广州-黄埔区  ...                     人事主管  a6497094b7babb44102cd7321dca3526   \n",
       " 29      广州  ...                           d6f4eaf9e8558c295673c93fe8af5efb   \n",
       " 30  广州-番禺区  ...                   人力行政经理  72f5a27210c71d32f5407cfd825f86a4   \n",
       " 31  广州-海珠区  ...                     招聘经理  49f425d89e58263262a4d84e0af55f9a   \n",
       " 32      广州  ...                       总监  cfbd355fd16026c369dca8db230a680f   \n",
       " 33      广州  ...                  市场总监cmo  deaa5be521bde1c0fd0bb6141bcd879c   \n",
       " 34      广州  ...                创始人 & CEO  7a08a50e7cb0cedc7a6177a014e20d4a   \n",
       " 35      广州  ...                           a4fadcf00aed55b828866d218ef586d8   \n",
       " 36  广州-海珠区  ...                    人事负责人  b36f95e567e6755d28a7a2a16782569c   \n",
       " 37  广州-黄埔区  ...                       HR  ba5752fb55ea9562e09ac4eb9df5c65e   \n",
       " 38  广州-番禺区  ...                           13887b71c9311edf66e3fe8f1091b174   \n",
       " 39      广州  ...                       HR  3539f39bbf4bb962c6f31a942edcd724   \n",
       " \n",
       "            recruiter.recruiterPhoto comp.compScale comp.compId  \\\n",
       " 0   5ae2e6738e50b1315468c9fa04a.jpg       500-999人   8772082.0   \n",
       " 1   647832318c03f04405e1598b08u.png       100-499人   8101094.0   \n",
       " 2   5f8f98648dbe6273dcf8515508u.jpg       500-999人   9283156.0   \n",
       " 3   5f8f9863f6d1ab58476f246a08u.jpg       500-999人   9283156.0   \n",
       " 4   5f8fa3a9dfb13a7dee343d4808u.png         50-99人         NaN   \n",
       " 5   5f8f986779c7cc70efbf36c008u.jpg       500-999人   9283156.0   \n",
       " 6   5f8f986bdfb13a7dee342f2108u.jpg          1-49人  12657589.0   \n",
       " 7   5f8f9868f6d1ab58476f24a008u.jpg       100-499人   8101094.0   \n",
       " 8   5f8f9865ea60860b75384fa508u.jpg         50-99人  12836971.0   \n",
       " 9   5f8f9866dfb13a7dee342f1808u.jpg     1000-2000人   8913637.0   \n",
       " 10  5f8f9865ea60860b75384fa508u.jpg    5000-10000人   5576863.0   \n",
       " 11  5f8f986aea60860b75384fab08u.jpg     2000-5000人   7898133.0   \n",
       " 12  54d1e78c712e7147fd80b3ce01a.jpg       500-999人   7855207.0   \n",
       " 13  5f5b08549d37de587970f24107u.jpg    5000-10000人         NaN   \n",
       " 14  5f8f9866dfb13a7dee342f1808u.jpg       100-499人  12140795.0   \n",
       " 15  5f8f98698dbe6273dcf8516008u.jpg       500-999人   8596658.0   \n",
       " 16  5cec8666d3ced44864631b6807u.png    5000-10000人         NaN   \n",
       " 17  6357545295c1f4106df192ca08u.png       100-499人   9128264.0   \n",
       " 18  5f8f98648dbe6273dcf8515508u.jpg         50-99人   9919383.0   \n",
       " 19  5f8f9865ea60860b75384fa508u.jpg         50-99人  12861279.0   \n",
       " 20  5f8f98648dbe6273dcf8515508u.jpg         50-99人  13268219.0   \n",
       " 21  5f8f9865ea60860b75384fa508u.jpg          1-49人  13222381.0   \n",
       " 22  5f8f9865ea60860b75384fa508u.jpg          1-49人  10149075.0   \n",
       " 23  5f8f9868f6d1ab58476f24a008u.jpg    5000-10000人   3349721.0   \n",
       " 24  5f8f9868f6d1ab58476f24a008u.jpg          1-49人  13082931.0   \n",
       " 25  5f8f9866dfb13a7dee342f1808u.jpg         50-99人  13007319.0   \n",
       " 26  5f8f9865ea60860b75384fa508u.jpg          1-49人  12483499.0   \n",
       " 27  5f8f98648dbe6273dcf8515508u.jpg          1-49人   9611086.0   \n",
       " 28  5f8f9863f6d1ab58476f246a08u.jpg         50-99人  13352093.0   \n",
       " 29  5f8f9863f6d1ab58476f246a08u.jpg         50-99人  10266025.0   \n",
       " 30  5f8f9863f6d1ab58476f246a08u.jpg                 12276719.0   \n",
       " 31  5f8f986c79c7cc70efbf36c808u.jpg         50-99人   9327403.0   \n",
       " 32  62662b233bf66543590b09e104u.png          1-49人  13199547.0   \n",
       " 33  5fb22ad247dd594c3fb5a87605u.png       500-999人   9209991.0   \n",
       " 34  60ea7a47c6885e7f703ccab008u.png          1-49人  12830333.0   \n",
       " 35  5f8f9865ea60860b75384fa508u.jpg         50-99人  12986887.0   \n",
       " 36  5f8f98648dbe6273dcf8515508u.jpg          1-49人  13237679.0   \n",
       " 37  5f8f9865ea60860b75384fa508u.jpg         50-99人   9497373.0   \n",
       " 38  5f8f9865ea60860b75384fa508u.jpg     1000-2000人   9696287.0   \n",
       " 39  5f8f986c79c7cc70efbf36c808u.jpg          1-49人  12869413.0   \n",
       " \n",
       "                       comp.compLogo    comp.compName  \\\n",
       " 0   5bfe96c874719df0ac99185003a.png       香港安植集团有限公司   \n",
       " 1   5feadb54c95fba5858bcfdad05u.png     广州奥鹏能源科技有限公司   \n",
       " 2   60335ea200e91f04c68d28ad02u.png              梵蜜琳   \n",
       " 3   60335ea200e91f04c68d28ad02u.png              梵蜜琳   \n",
       " 4   60e2fe0bf3df194a3c48adb502u.png      某国内人力资源服务公司   \n",
       " 5   60335ea200e91f04c68d28ad02u.png              梵蜜琳   \n",
       " 6   61b07937d0458d53c627567e02u.jpg    广东白驹逸文化服饰有限公司   \n",
       " 7   5feadb54c95fba5858bcfdad05u.png     广州奥鹏能源科技有限公司   \n",
       " 8   61b07937d0458d53c627567e02u.jpg     广州乐美生物科技有限公司   \n",
       " 9   58d4e4817032b4d497b0ca4a05a.png             瀚森投资   \n",
       " 10  5bfe9b9f74719df0ac9a0e9603a.png             南方传媒   \n",
       " 11  54d1ea1b712e7147fd819ad002c.png           三雄极光照明   \n",
       " 12  5bfe8f4274719d35745a678503a.png           广东鼎湖山泉   \n",
       " 13  60e2fe0bf3df194a3c48adb502u.png     某广州机械/设备上市公司   \n",
       " 14  62d7ccdaaaf2716c96d933f508u.png              溪木源   \n",
       " 15  5ecf7e78f1b6f0697065968802u.jpg  广州康立明生物科技股份有限公司   \n",
       " 16  60e2fe0bf3df194a3c48adb502u.png            某知名公司   \n",
       " 17  614acc78b09b9f5bbe76be7f06u.png             优端环保   \n",
       " 18  6114d3012fa3cf25a48ded6d06u.png    广州爱课堂教育咨询有限公司   \n",
       " 19  61b07937d0458d53c627567e02u.jpg     广州善利信息科技有限公司   \n",
       " 20  63f6d0a91698640aa768567802u.png     广州云端共享实业有限公司   \n",
       " 21  61b07937d0458d53c627567e02u.jpg     广东韩世国际文化有限公司   \n",
       " 22  61b07937d0458d53c627567e02u.jpg    广州万卡联电子产品有限公司   \n",
       " 23  5bfea31a74719d2aa34c799a03a.png             老板电器   \n",
       " 24  61b07937d0458d53c627567e02u.jpg   因恩科技集团(佛山)有限公司   \n",
       " 25  61b07937d0458d53c627567e02u.jpg     瑞浩能源(广东)有限公司   \n",
       " 26  61b07937d0458d53c627567e02u.jpg  汉正家族办公室(广州)有限公司   \n",
       " 27  5b484de48e508f32d96e105204a.jpg    广州莱丝漾生物科技有限公司   \n",
       " 28  637448a0f4b84e543e9ce97a08u.png  广州无塑地球新材料科技有限公司   \n",
       " 29  5de4de81cd52473b94ead5b707u.jpg   优宠宠物食品(广东)有限公司   \n",
       " 30  61b07937d0458d53c627567e02u.jpg   广州童学们好文化创意有限公司   \n",
       " 31  63ac1458e77f707d602c1b4308u.png     广州雇者品牌咨询有限公司   \n",
       " 32  61b07937d0458d53c627567e02u.jpg  万浦森教育科技(佛山)有限公司   \n",
       " 33  5eb8c823f25402045742ee1903u.jpg          迈格森国际教育   \n",
       " 34  61a9d1fb6ac122095d1fba2205u.jpg             草本趣时   \n",
       " 35  618ccdc000290811a4df8d9105u.png               潮汐   \n",
       " 36  61b07937d0458d53c627567e02u.jpg  广州嘉上嘉商业经营管理有限公司   \n",
       " 37  5d424d6bcd394174d08fd65102u.jpg   广州版权产业服务中心有限公司   \n",
       " 38  5badbbc78e50b2deb624467404a.jpg    广东加拿达教育科技有限公司   \n",
       " 39  61b07937d0458d53c627567e02u.jpg   广州世家思享室内设计有限公司   \n",
       " \n",
       "                                    comp.link comp.compIndustry comp.compStage  \n",
       " 0    https://www.liepin.com/company/8772082/              医疗机构            NaN  \n",
       " 1    https://www.liepin.com/company/8101094/               新能源             A轮  \n",
       " 2    https://www.liepin.com/company/9283156/                日化            NaN  \n",
       " 3    https://www.liepin.com/company/9283156/                日化            NaN  \n",
       " 4                                                       人力资源服务            NaN  \n",
       " 5    https://www.liepin.com/company/9283156/                日化            NaN  \n",
       " 6   https://www.liepin.com/company/12657589/          服装/纺织/皮革            NaN  \n",
       " 7    https://www.liepin.com/company/8101094/               新能源             A轮  \n",
       " 8   https://www.liepin.com/company/12836971/            专业技术服务           战略投资  \n",
       " 9    https://www.liepin.com/company/8913637/           房地产开发经营            NaN  \n",
       " 10   https://www.liepin.com/company/5576863/          广播/影视/录音         沪深A股上市  \n",
       " 11   https://www.liepin.com/company/7898133/       电子/半导体/集成电路         沪深A股上市  \n",
       " 12   https://www.liepin.com/company/7855207/          食品/饮料/酒水            NaN  \n",
       " 13                                                       机械/设备            已上市  \n",
       " 14  https://www.liepin.com/company/12140795/                日化             B轮  \n",
       " 15   https://www.liepin.com/company/8596658/                制药             D轮  \n",
       " 16                                                       机械/设备            已上市  \n",
       " 17   https://www.liepin.com/company/9128264/                环保             其他  \n",
       " 18   https://www.liepin.com/company/9919383/              培训服务          融资未公开  \n",
       " 19  https://www.liepin.com/company/12861279/             计算机软件            NaN  \n",
       " 20  https://www.liepin.com/company/13268219/           房地产开发经营            NaN  \n",
       " 21  https://www.liepin.com/company/13222381/            专业技术服务            NaN  \n",
       " 22  https://www.liepin.com/company/10149075/             批发/零售          融资未公开  \n",
       " 23   https://www.liepin.com/company/3349721/                家电         沪深A股上市  \n",
       " 24  https://www.liepin.com/company/13082931/            专业技术服务            NaN  \n",
       " 25  https://www.liepin.com/company/13007319/            专业技术服务            NaN  \n",
       " 26  https://www.liepin.com/company/12483499/            专业技术服务            NaN  \n",
       " 27   https://www.liepin.com/company/9611086/               互联网            NaN  \n",
       " 28  https://www.liepin.com/company/13352093/                环保            NaN  \n",
       " 29  https://www.liepin.com/company/10266025/             批发/零售            NaN  \n",
       " 30  https://www.liepin.com/company/12276719/            专业技术服务            NaN  \n",
       " 31   https://www.liepin.com/company/9327403/          广告/公关/会展            NaN  \n",
       " 32  https://www.liepin.com/company/13199547/             计算机软件            NaN  \n",
       " 33   https://www.liepin.com/company/9209991/              培训服务            NaN  \n",
       " 34  https://www.liepin.com/company/12830333/          食品/饮料/酒水            天使轮  \n",
       " 35  https://www.liepin.com/company/12986887/               互联网             A轮  \n",
       " 36  https://www.liepin.com/company/13237679/            专业技术服务            NaN  \n",
       " 37   https://www.liepin.com/company/9497373/          广播/影视/录音            NaN  \n",
       " 38   https://www.liepin.com/company/9696287/              培训服务            NaN  \n",
       " 39  https://www.liepin.com/company/12869413/            专业技术服务            NaN  \n",
       " \n",
       " [40 rows x 31 columns],\n",
       "                                              dataInfo  \\\n",
       " 0   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 1   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 2   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 3   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 4   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 5   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 6   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 7   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 8   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 9   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 10  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 11  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 12  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 13  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 14  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 15  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 16  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 17  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 18  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 19  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 20  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 21  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 22  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 23  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 24  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 25  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 26  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 27  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 28  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 29  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 30  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 31  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 32  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 33  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 34  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 35  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 36  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 37  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 38  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " 39  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       " \n",
       "                                            dataParams  \\\n",
       " 0   {\"recruiterName\":\"张女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 1   {\"recruiterName\":\"李先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 2   {\"recruiterName\":\"潘女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 3   {\"recruiterName\":\"李先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 4   {\"recruiterName\":\"杨女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 5   {\"recruiterName\":\"宣先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 6   {\"recruiterName\":\"古女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 7   {\"recruiterName\":\"李女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 8   {\"recruiterName\":\"刘女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 9   {\"recruiterName\":\"唐女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 10  {\"recruiterName\":\"黄女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 11  {\"recruiterName\":\"林女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 12  {\"recruiterName\":\"叶女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 13  {\"recruiterName\":\"旷女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 14  {\"recruiterName\":\"杨先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 15  {\"recruiterName\":\"陈先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 16  {\"recruiterName\":\"黎女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 17  {\"recruiterName\":\"刘先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 18  {\"recruiterName\":\"黄女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 19  {\"recruiterName\":\"周先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 20  {\"recruiterName\":\"蔡女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 21  {\"recruiterName\":\"李女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 22  {\"recruiterName\":\"宋女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 23  {\"recruiterName\":\"刘女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 24  {\"recruiterName\":\"陈女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 25  {\"recruiterName\":\"陈女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 26  {\"recruiterName\":\"郝女士\",\"jobKind\":\"1\",\"jobId\":\"...   \n",
       " 27  {\"recruiterName\":\"梁先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 28  {\"recruiterName\":\"梁女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 29  {\"recruiterName\":\"邹先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 30  {\"recruiterName\":\"陈女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 31  {\"recruiterName\":\"吴先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 32  {\"recruiterName\":\"梁先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 33  {\"recruiterName\":\"区女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 34  {\"recruiterName\":\"邱女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 35  {\"recruiterName\":\"孔女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 36  {\"recruiterName\":\"陈先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 37  {\"recruiterName\":\"陈先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 38  {\"recruiterName\":\"田先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " 39  {\"recruiterName\":\"原女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       " \n",
       "                                            job.labels job.jobKind job.jobId  \\\n",
       " 0                                         [文案, 新媒体运营]           2  38748601   \n",
       " 1   [数据运营, 用户运营, 内容运营, 新媒体运营, 平台运营, 策略运营, 抖音平台, 文学...           2  58982139   \n",
       " 2   [新媒体运营, 平台运营, 小红书平台, 新媒体平台, 用户运营, 产品运营, 电商运营, ...           2  57122521   \n",
       " 3                    [新媒体运营, 广告投放/流量运营, 新媒体平台, 自媒体平台]           2  54032829   \n",
       " 4         [平台运营, 时政类, 新闻类, 新媒体运营, 自媒体平台, 新媒体平台, to B]           2  56156321   \n",
       " 5                                             [新媒体运营]           2  55038627   \n",
       " 6                                 [用户运营, 新媒体运营, 内容运营]           2  39298335   \n",
       " 7               [营销策划, 市场推广, 内容运营, 新媒体运营, 社群运营, 广告投放]           2  35536171   \n",
       " 8   [市场运营, 新媒体运营, 策略运营, 短视频运营, 活动运营, 专业服务, IT/互联网/...           2  58259047   \n",
       " 9   [新媒体运营, 自媒体运营, 内容运营, 平台运营, 消费品, 小红书平台, 微博平台, 微...           2  57131845   \n",
       " 10                               [新媒体运营, 小红书平台, 抖音平台]           2  58112629   \n",
       " 11  [新媒体运营, 新媒体平台, to C, 法律类, 市场运营, 品牌运营, 线上运营, 线下...           2  51103939   \n",
       " 12                          [新媒体运营, 抖音平台, 快手平台, 电商运营]           2  52901207   \n",
       " 13                                            [新媒体运营]           2  43974091   \n",
       " 14  [内容运营, 产品运营, 自媒体运营, 制药/医疗, 线上运营, to C, 微信公众号, ...           2  48893159   \n",
       " 15                                            [新媒体运营]           2  44206297   \n",
       " 16  [新媒体运营, 文案, 网络营销, 营销策划, 市场策划, 市场推广, 广告投放, 渠道运营...           2  29526233   \n",
       " 17  [新媒体运营, 内容运营, 社群运营, 市场策划, 营销策划, 网络营销, 市场推广, 文案...           2  29446419   \n",
       " 18  [新媒体运营, 时政类, 内容运营, 策略运营, 粉丝运营, 平台运营, 新媒体平台, 自媒...           2  49677819   \n",
       " 19                                            [新媒体运营]           2  37545255   \n",
       " 20  [内容运营, 品牌运营, 新媒体运营, 小红书平台, 抖音平台, 快手平台, 新媒体平台, ...           2  57697263   \n",
       " 21                                            [新媒体运营]           2  34194167   \n",
       " 22                        [新媒体运营, 用户运营, 新媒体平台, 自媒体平台]           2  47573075   \n",
       " 23                  [平台运营, 粉丝运营, 新媒体运营, 新媒体平台, 自媒体平台]           2  56494605   \n",
       " 24                                   [新媒体运营, 抖音, 小红书]           2  58642755   \n",
       " 25                 [新媒体运营, 小红书平台, 抖音平台, 自媒体平台, 新媒体平台]           2  57945951   \n",
       " 26                                            [小红书运营]           1  46522839   \n",
       " 27            [平台运营, 内容运营, 新媒体运营, 新媒体平台, 自媒体平台, 直播平台]           2  55091457   \n",
       " 28  [新媒体运营, 内容运营, 短视频运营, 品牌运营, 平台运营, 广告投放/流量运营, 抖音...           2  51248723   \n",
       " 29  [新媒体运营, 小红书平台, 内容运营, 自媒体运营, 教育培训, 线上运营, to C, ...           2  56778397   \n",
       " 30                                             [线上运营]           2  58262247   \n",
       " 31             [新媒体运营, 内容运营, 自媒体运营, 广告投放/流量运营, 信息流优化]           2  46262573   \n",
       " 32                       [活动策划, 新媒体运营, 内容运营, 云计算/大数据]           2  52219653   \n",
       " 33                                      [内容运营, 新媒体运营]           2  48164529   \n",
       " 34                                            [新媒体运营]           2  27648033   \n",
       " 35                                 [粉丝运营, 活动运营, 产品运营]           2  47231617   \n",
       " 36                                 [市场推广, 广告投放, 网店运营]           2  29679947   \n",
       " 37  [新媒体运营, 网络推广, 小红书平台, 微博平台, 新媒体平台, 微信平台, 自媒体平台,...           2  37338465   \n",
       " 38                   [内容运营, 新媒体运营, 微信公众号, 营养研发, 产品研发]           2  55724925   \n",
       " 39                                [新媒体运营, 品牌运营, 内容创作]           2  55988605   \n",
       " \n",
       "    job.requireWorkYears             job.title  job.salary  job.dq  job.topJob  \\\n",
       " 0                  1-3年               新媒体运营专员        5-8k      广州       False   \n",
       " 1                 5-10年               新媒体运营总监      20-35k  广州-海珠区       False   \n",
       " 2                 5-10年                 新媒体运营       8-13k  广州-白云区       False   \n",
       " 3                  3-5年  新媒体运营主管（高级运营）周末双休 统招       8-12k      广州       False   \n",
       " 4                  3-5年               新媒体运营主管       8-12k  广州-越秀区       False   \n",
       " 5                  3-5年               新媒体运营经理      12-24k  广州-白云区       False   \n",
       " 6                  3-5年               新媒体运营总监      15-25k      广州       False   \n",
       " 7                  1-3年            新媒体运营（商务侧）        5-8k  广州-海珠区       False   \n",
       " 8                  3-5年               新媒体运营主管      15-25k  广州-白云区       False   \n",
       " 9                  3-5年          新媒体运营主管/高级主管       8-16k  广州-黄埔区       False   \n",
       " 10                 3-5年             新媒体运营（双休）        6-9k  广州-增城区       False   \n",
       " 11                 3-5年             新媒体运营高级专员       8-12k  广州-天河区       False   \n",
       " 12                 3-5年                 新媒体运营      12-28k  广州-天河区       False   \n",
       " 13                 3-5年                 新媒体运营        6-9k  广州-海珠区       False   \n",
       " 14                 1-3年                 新媒体运营      20-25k      广州       False   \n",
       " 15                 经验不限                 新媒体运营       5-10k      广州       False   \n",
       " 16                 3-5年                 新媒体运营       8-10k  广州-番禺区       False   \n",
       " 17                 3-5年                 新媒体运营       7-12k      广州       False   \n",
       " 18                 1-3年                 新媒体运营       6-10k  广州-海珠区       False   \n",
       " 19                 1-3年                 新媒体运营        5-8k      广州       False   \n",
       " 20                 1-3年               新媒体运营经理      10-20k  广州-黄埔区       False   \n",
       " 21                 1-3年                 新媒体运营        5-8k  广州-花都区       False   \n",
       " 22                 经验不限                 新媒体运营        5-8k  广州-白云区       False   \n",
       " 23                 3-5年          酒店新媒体运营经理/主管       6-12k  广州-天河区       False   \n",
       " 24                 3-5年                 新媒体运营       8-13k  广州-黄埔区       False   \n",
       " 25                 1-3年               新媒体运营专员   8-12k·14薪  广州-天河区       False   \n",
       " 26                 3-5年               新媒体运营经理      15-20k      广州       False   \n",
       " 27                 1-3年   短视频新媒体运营(营销管理中心-广州)  12-16k·13薪  广州-白云区       False   \n",
       " 28                 1-3年               新媒体运营主管      10-15k  广州-白云区       False   \n",
       " 29                 1-3年               新媒体运营主管      15-25k  广州-番禺区       False   \n",
       " 30                 1-3年                 新媒体运营        6-8k  广州-黄埔区       False   \n",
       " 31                 3-5年               新媒体运营主管   8-15k·13薪  广州-天河区       False   \n",
       " 32                 1-3年                 新媒体运营       6-11k  广州-越秀区       False   \n",
       " 33                 经验不限               新媒体运营经理       9-14k      广州       False   \n",
       " 34                 1-3年                 新媒体运营       6-10k  广州-天河区       False   \n",
       " 35                 1-3年             新媒体运营策划专员       8-13k  广州-越秀区       False   \n",
       " 36                 1-3年                 新媒体运营       6-10k  广州-荔湾区       False   \n",
       " 37                 3-5年               新媒体运营主管      15-30k  广州-番禺区       False   \n",
       " 38                 1-3年            新媒体运营专员/主管  13-18k·13薪  广州-黄埔区       False   \n",
       " 39                 3-5年            新媒体运营经理/主管  15-22k·13薪      广州       False   \n",
       " \n",
       "     ... recruiter.imUserType             recruiter.recruiterId  \\\n",
       " 0   ...                    2  3ab6efcca718325c3765eb29f57e6bb3   \n",
       " 1   ...                    2  409fbe030e5a059d1c5aa715c2e15e97   \n",
       " 2   ...                    2  fe0bc9386a14ef0c0394408d2c42fdc3   \n",
       " 3   ...                    2  8b830d8ae6201c5384c3ec9985f70200   \n",
       " 4   ...                    2  e5c897da1c291ebcb1fda6e3f4aa13d8   \n",
       " 5   ...                    2  f56688edc34d5819042eb479f226abb5   \n",
       " 6   ...                    2  6c3df4162ccdacd3357d34cdc4ca6840   \n",
       " 7   ...                    2  62070fa7d4a16a23fe31540f88cb57d1   \n",
       " 8   ...                    2  c22a7cc55dd19ece7b7c212907099f7d   \n",
       " 9   ...                    2  b06d9f943c8070ae2994b270cb1fde35   \n",
       " 10  ...                    2  1330a0291a8d630219704b9226dd28eb   \n",
       " 11  ...                    2  fd27b22ae6636a0972d29a44d83b478e   \n",
       " 12  ...                    2  2df054af770ad73c509b5a92d3ff9318   \n",
       " 13  ...                    2  0d65a9ff0b67638fbdc280f20fa4c432   \n",
       " 14  ...                    2  ab61cb0474cb51d8d78887fe4bca71cd   \n",
       " 15  ...                    2  e21f30e571c993b3920d272bcabd02c1   \n",
       " 16  ...                    2  8c3ad676f680b94377a5ce05d35d50e4   \n",
       " 17  ...                    2  2dc4f43dbadf88b1e7014cc4163861b1   \n",
       " 18  ...                    2  a8455711cef4491217db8ed9e8875a6b   \n",
       " 19  ...                    2  d2bb2bada3d41e0da675ff19a3c66f9b   \n",
       " 20  ...                    2  50e4790bda7c7061938172bfedd5833b   \n",
       " 21  ...                    2  54a649a34f163ee781a3ea90c1bc34f5   \n",
       " 22  ...                    2  bea5f4af9a4b334f3eb943e02311ff5b   \n",
       " 23  ...                    2  ed26876a8d1a781db7328888f23e8fe6   \n",
       " 24  ...                    2  44579f69f365989b6a9b03b983ac2325   \n",
       " 25  ...                    2  f69cb9531f2116329f177de5c20a6023   \n",
       " 26  ...                    2  aa14e5262164f20ef54cdd1d0bccea30   \n",
       " 27  ...                    2  012ed4e9693c1065b4fe48a36fbb0cba   \n",
       " 28  ...                    2  b7408894d77512a1c91ea89a6d33e56e   \n",
       " 29  ...                    2  3be5041f016f95dd08f67f6dee75986c   \n",
       " 30  ...                    2  ab0e098393448440497e1b81567e6512   \n",
       " 31  ...                    2  427947ea8403b2e3a6803ddbb25c771f   \n",
       " 32  ...                    2  5011ad6b64009a3c6758ce4d6e0f7637   \n",
       " 33  ...                    2  a403b42a795f4865732b762b1cf94f61   \n",
       " 34  ...                    2  cbdd46fa6ce86dd02aa7e7f3e5b82b30   \n",
       " 35  ...                    2  098eb5f7ad2f9a2543bf0bc6bf2ff66d   \n",
       " 36  ...                    2  cc22833303c24163bd07f238b8894cc7   \n",
       " 37  ...                    2  4c737eaf5b739f8864ba3c8e569bdadd   \n",
       " 38  ...                    2  5553774e1dfc4bd94e578f26109225be   \n",
       " 39  ...                    2  7c14d50429358cdc06e2eb9d4bc6835f   \n",
       " \n",
       "            recruiter.recruiterPhoto comp.compId comp.compStage  \\\n",
       " 0   6089209059d64736fc6e660306u.png  12719631.0          融资未公开   \n",
       " 1   5f8f986c79c7cc70efbf36c808u.jpg  12849281.0            天使轮   \n",
       " 2   5f8f9865ea60860b75384fa508u.jpg   9128264.0             其他   \n",
       " 3   56a97fab45ce2797ac3ddbb306a.png   8092060.0            NaN   \n",
       " 4   5f8f986779c7cc70efbf36c008u.jpg  13132807.0            NaN   \n",
       " 5   5f8f986aea60860b75384fab08u.jpg   7943190.0            NaN   \n",
       " 6   5f8f98648dbe6273dcf8515508u.jpg   9921697.0          新三板上市   \n",
       " 7   5f8f98648dbe6273dcf8515508u.jpg  12502895.0            NaN   \n",
       " 8   6406904d3c488720c74db2c804u.png  13130287.0            NaN   \n",
       " 9   5f8f9863f6d1ab58476f246a08u.jpg   1537771.0            NaN   \n",
       " 10  5f8f986779c7cc70efbf36c008u.jpg  13522063.0            NaN   \n",
       " 11  5f8f9863f6d1ab58476f246a08u.jpg   9809305.0           战略投资   \n",
       " 12  5f8f986779c7cc70efbf36c008u.jpg  13260221.0          融资未公开   \n",
       " 13  60e6907bf78b2941fbeca51a04u.png  12825881.0            NaN   \n",
       " 14  624cfada8c74e57d84e93ad503u.png  12777195.0            NaN   \n",
       " 15  5f8f986aea60860b75384fab08u.jpg  12969311.0            NaN   \n",
       " 16  5f8f9863f6d1ab58476f246a08u.jpg  10244097.0          融资未公开   \n",
       " 17  5f8f986c79c7cc70efbf36c808u.jpg  10244097.0          融资未公开   \n",
       " 18  5f8f9863f6d1ab58476f246a08u.jpg  12307785.0            NaN   \n",
       " 19  5f8f986c79c7cc70efbf36c808u.jpg   9421273.0          融资未公开   \n",
       " 20  5f8f9865ea60860b75384fa508u.jpg   7854025.0         沪深A股上市   \n",
       " 21  5f8f9866dfb13a7dee342f1808u.jpg  12496283.0            NaN   \n",
       " 22  5f8f9865ea60860b75384fa508u.jpg  13092657.0            NaN   \n",
       " 23  5f8f9863f6d1ab58476f246a08u.jpg   8114286.0          融资未公开   \n",
       " 24  5f8f9865ea60860b75384fa508u.jpg  13546769.0            NaN   \n",
       " 25  57f9f44762f0be8fb7b092a706a.jpg   8370684.0          融资未公开   \n",
       " 26  5f8fa3baf6d1ab58476f324908u.png         NaN           战略融资   \n",
       " 27  5b9772498e50a3257f4489f804a.jpg   7943190.0            NaN   \n",
       " 28  5f8f9863f6d1ab58476f246a08u.jpg   9283156.0            NaN   \n",
       " 29  5f8f986c79c7cc70efbf36c808u.jpg   7646115.0             B轮   \n",
       " 30  5f8f98648dbe6273dcf8515508u.jpg  13175449.0            NaN   \n",
       " 31  5f8f986bdfb13a7dee342f2108u.jpg  10016817.0            NaN   \n",
       " 32  630c468785d83127970f711a02u.png  13114535.0            天使轮   \n",
       " 33  5f8f9863f6d1ab58476f246a08u.jpg   8102315.0            NaN   \n",
       " 34  5975f6bc7032648741bbfb0206a.png  10136743.0            NaN   \n",
       " 35  5f8f9866dfb13a7dee342f1808u.jpg   9325885.0          融资未公开   \n",
       " 36  5f8f986aea60860b75384fab08u.jpg  12300683.0          融资未公开   \n",
       " 37  5f8f986aea60860b75384fab08u.jpg  12646723.0          融资未公开   \n",
       " 38  5f8f986c79c7cc70efbf36c808u.jpg   8080810.0         沪深A股上市   \n",
       " 39  5f8f98648dbe6273dcf8515508u.jpg   8053046.0            NaN   \n",
       " \n",
       "                       comp.compLogo comp.compScale       comp.compName  \\\n",
       " 0   61b07937d0458d53c627567e02u.jpg          1-49人        广州奥盛展览顾问有限公司   \n",
       " 1   61b07937d0458d53c627567e02u.jpg          1-49人                 点竞石   \n",
       " 2   614acc78b09b9f5bbe76be7f06u.png       100-499人                优端环保   \n",
       " 3   5bfe969f74719df0ac990fee03a.png     2000-5000人          亿达信息技术有限公司   \n",
       " 4   61b07937d0458d53c627567e02u.jpg         50-99人      广州维儿康专科门诊部有限公司   \n",
       " 5   6166904c0270aa179ab212c001u.png       10000人以上                东呈集团   \n",
       " 6   5cb994479fae687d432d090401u.png       100-499人     广州市游龙御驾广告股份有限公司   \n",
       " 7   61b07937d0458d53c627567e02u.jpg          1-49人                点金数据   \n",
       " 8   63981b1270463e0c3a221e9407u.png         50-99人              立德国际物流   \n",
       " 9   620da928ee67752311661a4806u.png     1000-2000人  环亚化妆品（滋源/美肤宝/法兰琳卡）   \n",
       " 10  61b07937d0458d53c627567e02u.jpg       100-499人          广东南枝科技有限公司   \n",
       " 11  61b07937d0458d53c627567e02u.jpg         50-99人      苏州艾特律宝智能科技有限公司   \n",
       " 12  62c4377765d34f65a0106d0603u.jpg       100-499人               加厨宝食品   \n",
       " 13  61b07937d0458d53c627567e02u.jpg          1-49人       广州市福民家庭服务有限公司   \n",
       " 14  64157bc15f781e5cf71dc05f07u.jpg          1-49人                丙午经方   \n",
       " 15  61b07937d0458d53c627567e02u.jpg         50-99人    春男壹家(广州)文化传媒有限公司   \n",
       " 16  61b07937d0458d53c627567e02u.jpg                     君康生物科技(广州)有限公司   \n",
       " 17  61b07937d0458d53c627567e02u.jpg                     君康生物科技(广州)有限公司   \n",
       " 18  60d5805c8491bd494a8ca2fe01u.jpg         50-99人           SENZA智达盛世   \n",
       " 19  603466915f705308ebfce72106u.jpg       100-499人                南芯医疗   \n",
       " 20  5bfe95c674719df0ac98e51303a.png    5000-10000人                视源股份   \n",
       " 21  61b07937d0458d53c627567e02u.jpg         50-99人        北京可多网络科技有限公司   \n",
       " 22  620dda8369a8e50e6bcbb70508u.jpg          1-49人              仪美生物科技   \n",
       " 23  60965bd7acec625fb87e734304u.png       500-999人              雅阁酒店集团   \n",
       " 24  61b07937d0458d53c627567e02u.jpg          1-49人                寻梦山海   \n",
       " 25  592956467032882fc3995f6704a.jpg       100-499人                卓动科技   \n",
       " 26  60e2fe0bf3df194a3c48adb502u.png    5000-10000人         某厦门大型室内娱乐公司   \n",
       " 27  6166904c0270aa179ab212c001u.png       10000人以上                东呈集团   \n",
       " 28  60335ea200e91f04c68d28ad02u.png       500-999人                 梵蜜琳   \n",
       " 29  5bfe9ce174719d2aa34b485b03a.png     1000-2000人                邢帅教育   \n",
       " 30  62afd753ada8602492a882e403u.png         50-99人      广州科松医疗智能科技有限公司   \n",
       " 31  5d26aa823fa7ce27b2b2a75802u.jpg     1000-2000人                住方科技   \n",
       " 32  61b208e8afe5be721cbce7f002u.jpg         50-99人       广州众成大数据科技有限公司   \n",
       " 33  61b07937d0458d53c627567e02u.jpg         50-99人          广州禾易广告有限公司   \n",
       " 34  5d9eef74bf6c9008d9840ea301u.jpg       100-499人        广州星达品牌管理有限公司   \n",
       " 35  6041862fb894721491d4588205u.png       100-499人                仁脉咨询   \n",
       " 36  5f02f600543a971969e7d70a06u.jpg         50-99人         广州市悍森服饰有限公司   \n",
       " 37  61b07937d0458d53c627567e02u.jpg         50-99人       广州市天禾美意贸易有限公司   \n",
       " 38  5ec39993f2540204574caa5008u.jpg     2000-5000人                汤臣倍健   \n",
       " 39  5cce405a9fae687d43595ab903u.jpg    5000-10000人                裕丰地产   \n",
       " \n",
       "                                    comp.link  comp.compIndustry  \n",
       " 0   https://www.liepin.com/company/12719631/           广告/公关/会展  \n",
       " 1   https://www.liepin.com/company/12849281/               电子商务  \n",
       " 2    https://www.liepin.com/company/9128264/                 环保  \n",
       " 3    https://www.liepin.com/company/8092060/              计算机软件  \n",
       " 4   https://www.liepin.com/company/13132807/               医疗机构  \n",
       " 5    https://www.liepin.com/company/7943190/              酒店/民宿  \n",
       " 6    https://www.liepin.com/company/9921697/             专业技术服务  \n",
       " 7   https://www.liepin.com/company/12502895/              计算机软件  \n",
       " 8   https://www.liepin.com/company/13130287/           货运/物流/仓储  \n",
       " 9    https://www.liepin.com/company/1537771/                 日化  \n",
       " 10  https://www.liepin.com/company/13522063/              酒店/民宿  \n",
       " 11   https://www.liepin.com/company/9809305/               人工智能  \n",
       " 12  https://www.liepin.com/company/13260221/              批发/零售  \n",
       " 13  https://www.liepin.com/company/12825881/             专业技术服务  \n",
       " 14  https://www.liepin.com/company/12777195/               IT服务  \n",
       " 15  https://www.liepin.com/company/12969311/               培训服务  \n",
       " 16  https://www.liepin.com/company/10244097/               培训服务  \n",
       " 17  https://www.liepin.com/company/10244097/               培训服务  \n",
       " 18  https://www.liepin.com/company/12307785/           汽车交易/后市场  \n",
       " 19   https://www.liepin.com/company/9421273/               生物技术  \n",
       " 20   https://www.liepin.com/company/7854025/              计算机软件  \n",
       " 21  https://www.liepin.com/company/12496283/                NaN  \n",
       " 22  https://www.liepin.com/company/13092657/             专业技术服务  \n",
       " 23   https://www.liepin.com/company/8114286/              酒店/民宿  \n",
       " 24  https://www.liepin.com/company/13546769/               电子商务  \n",
       " 25   https://www.liepin.com/company/8370684/                 游戏  \n",
       " 26                                                         室内娱乐  \n",
       " 27   https://www.liepin.com/company/7943190/              酒店/民宿  \n",
       " 28   https://www.liepin.com/company/9283156/                 日化  \n",
       " 29   https://www.liepin.com/company/7646115/               培训服务  \n",
       " 30  https://www.liepin.com/company/13175449/               医疗器械  \n",
       " 31  https://www.liepin.com/company/10016817/               工程施工  \n",
       " 32  https://www.liepin.com/company/13114535/            云计算/大数据  \n",
       " 33   https://www.liepin.com/company/8102315/           广告/公关/会展  \n",
       " 34  https://www.liepin.com/company/10136743/             专业技术服务  \n",
       " 35   https://www.liepin.com/company/9325885/               培训服务  \n",
       " 36  https://www.liepin.com/company/12300683/              批发/零售  \n",
       " 37  https://www.liepin.com/company/12646723/                NaN  \n",
       " 38   https://www.liepin.com/company/8080810/           食品/饮料/酒水  \n",
       " 39   https://www.liepin.com/company/8053046/           房地产租赁/中介  \n",
       " \n",
       " [40 rows x 31 columns]]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "0fdf0151",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['dataParams', 'dataInfo', 'job.labels', 'job.requireWorkYears',\n",
       "       'job.refreshTime', 'job.jobId', 'job.title', 'job.salary', 'job.dq',\n",
       "       'job.jobKind', 'job.topJob', 'job.link', 'job.pcOuterLink',\n",
       "       'job.h5OuterLink', 'job.advViewFlag', 'job.dataPromId',\n",
       "       'job.requireEduLevel', 'recruiter.chatted', 'recruiter.imId',\n",
       "       'recruiter.imUserType', 'recruiter.recruiterName',\n",
       "       'recruiter.recruiterTitle', 'recruiter.recruiterId',\n",
       "       'recruiter.recruiterPhoto', 'comp.compId', 'comp.compScale',\n",
       "       'comp.compName', 'comp.compStage', 'comp.compLogo', 'comp.link',\n",
       "       'comp.compIndustry'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df = pd.concat(df)\n",
    "new_df.columns\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "f4136507",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataParams</th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterTitle</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{\"userId\":\"e2caf11372385bc816c460471bf607a4\",\"...</td>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>[新媒体运营, 线上运营, 线下运营, to B, to C, 短视频运营, 教育培训]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20230607160435</td>\n",
       "      <td>50472999</td>\n",
       "      <td>抖音短视频运营</td>\n",
       "      <td>8-20k</td>\n",
       "      <td>广州</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>HR</td>\n",
       "      <td>e2caf11372385bc816c460471bf607a4</td>\n",
       "      <td>62a9c3d83857652feba079bb01u.png</td>\n",
       "      <td>9681783.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广州时代华商人才培训股份有限公司</td>\n",
       "      <td>新三板上市</td>\n",
       "      <td>62cbe259e333d8014ebbc41f06u.png</td>\n",
       "      <td>https://www.liepin.com/company/9681783/</td>\n",
       "      <td>咨询服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{\"userId\":\"1e0b4e23c1a8a1cf9b7db259246dbaf9\",\"...</td>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>[]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20230510172530</td>\n",
       "      <td>58454571</td>\n",
       "      <td>新媒体运营总监</td>\n",
       "      <td>30-45k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>1e0b4e23c1a8a1cf9b7db259246dbaf9</td>\n",
       "      <td>5f8f9868f6d1ab58476f24a008u.jpg</td>\n",
       "      <td>13503443.0</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>广州市冠尚玉文化传媒有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6414f294cad5c51171a71ae304u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13503443/</td>\n",
       "      <td>珠宝/首饰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{\"userId\":\"f4d1f78d4a4a4aad415e6e85dd3bd7f2\",\"...</td>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>[新媒体运营, 内容运营, 品牌运营, 策略运营, 自媒体运营, 自媒体平台, 新媒体平台,...</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20230531014630</td>\n",
       "      <td>58966549</td>\n",
       "      <td>办公室主管 (偏新媒体运营方向）</td>\n",
       "      <td>12-16k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>总经理</td>\n",
       "      <td>f4d1f78d4a4a4aad415e6e85dd3bd7f2</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>13469371.0</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>广州惠和营销咨询管理有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6413a1c99533bc0e50173d8a05u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13469371/</td>\n",
       "      <td>其他商务服务业</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{\"userId\":\"218330ba00edd6dffa450ac44d803cf9\",\"...</td>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>[新媒体运营, 自媒体运营, 新闻类, 粉丝运营, 活动策划, 策略运营]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20190904120349</td>\n",
       "      <td>23157619</td>\n",
       "      <td>新媒体运营总监</td>\n",
       "      <td>8-12k</td>\n",
       "      <td>广州</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>人事专员</td>\n",
       "      <td>218330ba00edd6dffa450ac44d803cf9</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>10121385.0</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>广东斌锋安全服务有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/10121385/</td>\n",
       "      <td>专业技术服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{\"userId\":\"ea604555b926fe4c7bed7efb3d58ab91\",\"...</td>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>[新媒体运营, 短视频, 抖音运营, 护肤行业]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20211105113707</td>\n",
       "      <td>44492751</td>\n",
       "      <td>短视频/新媒体运营总监</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>人事行政经理</td>\n",
       "      <td>ea604555b926fe4c7bed7efb3d58ab91</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>12879953.0</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>广州鬼谷信息科技有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/12879953/</td>\n",
       "      <td>批发/零售</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>{\"recruiterName\":\"孔女士\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>[粉丝运营, 活动运营, 产品运营]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20220324142835</td>\n",
       "      <td>47231617</td>\n",
       "      <td>新媒体运营策划专员</td>\n",
       "      <td>8-13k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>098eb5f7ad2f9a2543bf0bc6bf2ff66d</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>9325885.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>仁脉咨询</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>6041862fb894721491d4588205u.png</td>\n",
       "      <td>https://www.liepin.com/company/9325885/</td>\n",
       "      <td>培训服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>{\"recruiterName\":\"陈先生\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>[市场推广, 广告投放, 网店运营]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20200706174956</td>\n",
       "      <td>29679947</td>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>6-10k</td>\n",
       "      <td>广州-荔湾区</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>总经理</td>\n",
       "      <td>cc22833303c24163bd07f238b8894cc7</td>\n",
       "      <td>5f8f986aea60860b75384fab08u.jpg</td>\n",
       "      <td>12300683.0</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>广州市悍森服饰有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>5f02f600543a971969e7d70a06u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/12300683/</td>\n",
       "      <td>批发/零售</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>{\"recruiterName\":\"陈先生\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>[新媒体运营, 网络推广, 小红书平台, 微博平台, 新媒体平台, 微信平台, 自媒体平台,...</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20210409102305</td>\n",
       "      <td>37338465</td>\n",
       "      <td>新媒体运营主管</td>\n",
       "      <td>15-30k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>常务</td>\n",
       "      <td>4c737eaf5b739f8864ba3c8e569bdadd</td>\n",
       "      <td>5f8f986aea60860b75384fab08u.jpg</td>\n",
       "      <td>12646723.0</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>广州市天禾美意贸易有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/12646723/</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>{\"recruiterName\":\"田先生\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>[内容运营, 新媒体运营, 微信公众号, 营养研发, 产品研发]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20230403000219</td>\n",
       "      <td>55724925</td>\n",
       "      <td>新媒体运营专员/主管</td>\n",
       "      <td>13-18k·13薪</td>\n",
       "      <td>广州-黄埔区</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>人力资源招聘HRBP绩效经理</td>\n",
       "      <td>5553774e1dfc4bd94e578f26109225be</td>\n",
       "      <td>5f8f986c79c7cc70efbf36c808u.jpg</td>\n",
       "      <td>8080810.0</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>汤臣倍健</td>\n",
       "      <td>沪深A股上市</td>\n",
       "      <td>5ec39993f2540204574caa5008u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/8080810/</td>\n",
       "      <td>食品/饮料/酒水</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>{\"recruiterName\":\"原女士\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>[新媒体运营, 品牌运营, 内容创作]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20230612085044</td>\n",
       "      <td>55988605</td>\n",
       "      <td>新媒体运营经理/主管</td>\n",
       "      <td>15-22k·13薪</td>\n",
       "      <td>广州</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>人才规划中心专员</td>\n",
       "      <td>7c14d50429358cdc06e2eb9d4bc6835f</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>8053046.0</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>裕丰地产</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5cce405a9fae687d43595ab903u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/8053046/</td>\n",
       "      <td>房地产租赁/中介</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>160 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           dataParams  \\\n",
       "0   {\"userId\":\"e2caf11372385bc816c460471bf607a4\",\"...   \n",
       "1   {\"userId\":\"1e0b4e23c1a8a1cf9b7db259246dbaf9\",\"...   \n",
       "2   {\"userId\":\"f4d1f78d4a4a4aad415e6e85dd3bd7f2\",\"...   \n",
       "3   {\"userId\":\"218330ba00edd6dffa450ac44d803cf9\",\"...   \n",
       "4   {\"userId\":\"ea604555b926fe4c7bed7efb3d58ab91\",\"...   \n",
       "..                                                ...   \n",
       "35  {\"recruiterName\":\"孔女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "36  {\"recruiterName\":\"陈先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "37  {\"recruiterName\":\"陈先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "38  {\"recruiterName\":\"田先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "39  {\"recruiterName\":\"原女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "\n",
       "                                             dataInfo  \\\n",
       "0   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "1   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "2   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "3   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "4   %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "..                                                ...   \n",
       "35  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "36  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "37  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "38  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "39  %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "\n",
       "                                           job.labels job.requireWorkYears  \\\n",
       "0        [新媒体运营, 线上运营, 线下运营, to B, to C, 短视频运营, 教育培训]                 1-3年   \n",
       "1                                                  []                 3-5年   \n",
       "2   [新媒体运营, 内容运营, 品牌运营, 策略运营, 自媒体运营, 自媒体平台, 新媒体平台,...                 1-3年   \n",
       "3               [新媒体运营, 自媒体运营, 新闻类, 粉丝运营, 活动策划, 策略运营]                 3-5年   \n",
       "4                            [新媒体运营, 短视频, 抖音运营, 护肤行业]                 3-5年   \n",
       "..                                                ...                  ...   \n",
       "35                                 [粉丝运营, 活动运营, 产品运营]                 1-3年   \n",
       "36                                 [市场推广, 广告投放, 网店运营]                 1-3年   \n",
       "37  [新媒体运营, 网络推广, 小红书平台, 微博平台, 新媒体平台, 微信平台, 自媒体平台,...                 3-5年   \n",
       "38                   [内容运营, 新媒体运营, 微信公众号, 营养研发, 产品研发]                 1-3年   \n",
       "39                                [新媒体运营, 品牌运营, 内容创作]                 3-5年   \n",
       "\n",
       "   job.refreshTime job.jobId         job.title  job.salary  job.dq  \\\n",
       "0   20230607160435  50472999           抖音短视频运营       8-20k      广州   \n",
       "1   20230510172530  58454571           新媒体运营总监      30-45k  广州-越秀区   \n",
       "2   20230531014630  58966549  办公室主管 (偏新媒体运营方向）      12-16k  广州-天河区   \n",
       "3   20190904120349  23157619           新媒体运营总监       8-12k      广州   \n",
       "4   20211105113707  44492751       短视频/新媒体运营总监      15-25k  广州-番禺区   \n",
       "..             ...       ...               ...         ...     ...   \n",
       "35  20220324142835  47231617         新媒体运营策划专员       8-13k  广州-越秀区   \n",
       "36  20200706174956  29679947             新媒体运营       6-10k  广州-荔湾区   \n",
       "37  20210409102305  37338465           新媒体运营主管      15-30k  广州-番禺区   \n",
       "38  20230403000219  55724925        新媒体运营专员/主管  13-18k·13薪  广州-黄埔区   \n",
       "39  20230612085044  55988605        新媒体运营经理/主管  15-22k·13薪      广州   \n",
       "\n",
       "   job.jobKind  ...  recruiter.recruiterTitle  \\\n",
       "0            2  ...                        HR   \n",
       "1            2  ...                             \n",
       "2            2  ...                       总经理   \n",
       "3            2  ...                      人事专员   \n",
       "4            2  ...                    人事行政经理   \n",
       "..         ...  ...                       ...   \n",
       "35           2  ...                             \n",
       "36           2  ...                       总经理   \n",
       "37           2  ...                        常务   \n",
       "38           2  ...            人力资源招聘HRBP绩效经理   \n",
       "39           2  ...                  人才规划中心专员   \n",
       "\n",
       "               recruiter.recruiterId         recruiter.recruiterPhoto  \\\n",
       "0   e2caf11372385bc816c460471bf607a4  62a9c3d83857652feba079bb01u.png   \n",
       "1   1e0b4e23c1a8a1cf9b7db259246dbaf9  5f8f9868f6d1ab58476f24a008u.jpg   \n",
       "2   f4d1f78d4a4a4aad415e6e85dd3bd7f2  5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "3   218330ba00edd6dffa450ac44d803cf9  5f8f9865ea60860b75384fa508u.jpg   \n",
       "4   ea604555b926fe4c7bed7efb3d58ab91  5f8f986779c7cc70efbf36c008u.jpg   \n",
       "..                               ...                              ...   \n",
       "35  098eb5f7ad2f9a2543bf0bc6bf2ff66d  5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "36  cc22833303c24163bd07f238b8894cc7  5f8f986aea60860b75384fab08u.jpg   \n",
       "37  4c737eaf5b739f8864ba3c8e569bdadd  5f8f986aea60860b75384fab08u.jpg   \n",
       "38  5553774e1dfc4bd94e578f26109225be  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       "39  7c14d50429358cdc06e2eb9d4bc6835f  5f8f98648dbe6273dcf8515508u.jpg   \n",
       "\n",
       "   comp.compId  comp.compScale     comp.compName comp.compStage  \\\n",
       "0    9681783.0        100-499人  广州时代华商人才培训股份有限公司          新三板上市   \n",
       "1   13503443.0        500-999人    广州市冠尚玉文化传媒有限公司            NaN   \n",
       "2   13469371.0          50-99人    广州惠和营销咨询管理有限公司            NaN   \n",
       "3   10121385.0           1-49人      广东斌锋安全服务有限公司            NaN   \n",
       "4   12879953.0          50-99人      广州鬼谷信息科技有限公司            NaN   \n",
       "..         ...             ...               ...            ...   \n",
       "35   9325885.0        100-499人              仁脉咨询          融资未公开   \n",
       "36  12300683.0          50-99人       广州市悍森服饰有限公司          融资未公开   \n",
       "37  12646723.0          50-99人     广州市天禾美意贸易有限公司          融资未公开   \n",
       "38   8080810.0      2000-5000人              汤臣倍健         沪深A股上市   \n",
       "39   8053046.0     5000-10000人              裕丰地产            NaN   \n",
       "\n",
       "                      comp.compLogo                                 comp.link  \\\n",
       "0   62cbe259e333d8014ebbc41f06u.png   https://www.liepin.com/company/9681783/   \n",
       "1   6414f294cad5c51171a71ae304u.jpg  https://www.liepin.com/company/13503443/   \n",
       "2   6413a1c99533bc0e50173d8a05u.jpg  https://www.liepin.com/company/13469371/   \n",
       "3   61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/10121385/   \n",
       "4   61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12879953/   \n",
       "..                              ...                                       ...   \n",
       "35  6041862fb894721491d4588205u.png   https://www.liepin.com/company/9325885/   \n",
       "36  5f02f600543a971969e7d70a06u.jpg  https://www.liepin.com/company/12300683/   \n",
       "37  61b07937d0458d53c627567e02u.jpg  https://www.liepin.com/company/12646723/   \n",
       "38  5ec39993f2540204574caa5008u.jpg   https://www.liepin.com/company/8080810/   \n",
       "39  5cce405a9fae687d43595ab903u.jpg   https://www.liepin.com/company/8053046/   \n",
       "\n",
       "   comp.compIndustry  \n",
       "0               咨询服务  \n",
       "1              珠宝/首饰  \n",
       "2            其他商务服务业  \n",
       "3             专业技术服务  \n",
       "4              批发/零售  \n",
       "..               ...  \n",
       "35              培训服务  \n",
       "36             批发/零售  \n",
       "37               NaN  \n",
       "38          食品/饮料/酒水  \n",
       "39          房地产租赁/中介  \n",
       "\n",
       "[160 rows x 31 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "f2eb0e86",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>工作标签</th>\n",
       "      <th>工作年限</th>\n",
       "      <th>工作名称</th>\n",
       "      <th>薪资</th>\n",
       "      <th>地区</th>\n",
       "      <th>学历要求</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>公司规模</th>\n",
       "      <th>公司融资情况</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[新媒体运营, 线上运营, 线下运营, to B, to C, 短视频运营, 教育培训]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>抖音短视频运营</td>\n",
       "      <td>8-20k</td>\n",
       "      <td>广州</td>\n",
       "      <td>大专</td>\n",
       "      <td>广州时代华商人才培训股份有限公司</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>咨询服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>新媒体运营总监</td>\n",
       "      <td>30-45k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>大专</td>\n",
       "      <td>广州市冠尚玉文化传媒有限公司</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>珠宝/首饰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[新媒体运营, 内容运营, 品牌运营, 策略运营, 自媒体运营, 自媒体平台, 新媒体平台,...</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>办公室主管 (偏新媒体运营方向）</td>\n",
       "      <td>12-16k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>本科</td>\n",
       "      <td>广州惠和营销咨询管理有限公司</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>其他商务服务业</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[新媒体运营, 自媒体运营, 新闻类, 粉丝运营, 活动策划, 策略运营]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>新媒体运营总监</td>\n",
       "      <td>8-12k</td>\n",
       "      <td>广州</td>\n",
       "      <td>大专</td>\n",
       "      <td>广东斌锋安全服务有限公司</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>专业技术服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[新媒体运营, 短视频, 抖音运营, 护肤行业]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>短视频/新媒体运营总监</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>广州鬼谷信息科技有限公司</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>批发/零售</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>[粉丝运营, 活动运营, 产品运营]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>新媒体运营策划专员</td>\n",
       "      <td>8-13k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>大专</td>\n",
       "      <td>仁脉咨询</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>培训服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>[市场推广, 广告投放, 网店运营]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>6-10k</td>\n",
       "      <td>广州-荔湾区</td>\n",
       "      <td>大专</td>\n",
       "      <td>广州市悍森服饰有限公司</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>批发/零售</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>[新媒体运营, 网络推广, 小红书平台, 微博平台, 新媒体平台, 微信平台, 自媒体平台,...</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>新媒体运营主管</td>\n",
       "      <td>15-30k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>广州市天禾美意贸易有限公司</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>[内容运营, 新媒体运营, 微信公众号, 营养研发, 产品研发]</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>新媒体运营专员/主管</td>\n",
       "      <td>13-18k·13薪</td>\n",
       "      <td>广州-黄埔区</td>\n",
       "      <td>硕士</td>\n",
       "      <td>汤臣倍健</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>食品/饮料/酒水</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>[新媒体运营, 品牌运营, 内容创作]</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>新媒体运营经理/主管</td>\n",
       "      <td>15-22k·13薪</td>\n",
       "      <td>广州</td>\n",
       "      <td>本科</td>\n",
       "      <td>裕丰地产</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>房地产租赁/中介</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>160 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 工作标签  工作年限              工作名称  \\\n",
       "0        [新媒体运营, 线上运营, 线下运营, to B, to C, 短视频运营, 教育培训]  1-3年           抖音短视频运营   \n",
       "1                                                  []  3-5年           新媒体运营总监   \n",
       "2   [新媒体运营, 内容运营, 品牌运营, 策略运营, 自媒体运营, 自媒体平台, 新媒体平台,...  1-3年  办公室主管 (偏新媒体运营方向）   \n",
       "3               [新媒体运营, 自媒体运营, 新闻类, 粉丝运营, 活动策划, 策略运营]  3-5年           新媒体运营总监   \n",
       "4                            [新媒体运营, 短视频, 抖音运营, 护肤行业]  3-5年       短视频/新媒体运营总监   \n",
       "..                                                ...   ...               ...   \n",
       "35                                 [粉丝运营, 活动运营, 产品运营]  1-3年         新媒体运营策划专员   \n",
       "36                                 [市场推广, 广告投放, 网店运营]  1-3年             新媒体运营   \n",
       "37  [新媒体运营, 网络推广, 小红书平台, 微博平台, 新媒体平台, 微信平台, 自媒体平台,...  3-5年           新媒体运营主管   \n",
       "38                   [内容运营, 新媒体运营, 微信公众号, 营养研发, 产品研发]  1-3年        新媒体运营专员/主管   \n",
       "39                                [新媒体运营, 品牌运营, 内容创作]  3-5年        新媒体运营经理/主管   \n",
       "\n",
       "            薪资      地区  学历要求              公司名称         公司规模    公司融资情况  \n",
       "0        8-20k      广州    大专  广州时代华商人才培训股份有限公司     100-499人      咨询服务  \n",
       "1       30-45k  广州-越秀区    大专    广州市冠尚玉文化传媒有限公司     500-999人     珠宝/首饰  \n",
       "2       12-16k  广州-天河区    本科    广州惠和营销咨询管理有限公司       50-99人   其他商务服务业  \n",
       "3        8-12k      广州    大专      广东斌锋安全服务有限公司        1-49人    专业技术服务  \n",
       "4       15-25k  广州-番禺区  学历不限      广州鬼谷信息科技有限公司       50-99人     批发/零售  \n",
       "..         ...     ...   ...               ...          ...       ...  \n",
       "35       8-13k  广州-越秀区    大专              仁脉咨询     100-499人      培训服务  \n",
       "36       6-10k  广州-荔湾区    大专       广州市悍森服饰有限公司       50-99人     批发/零售  \n",
       "37      15-30k  广州-番禺区  学历不限     广州市天禾美意贸易有限公司       50-99人       NaN  \n",
       "38  13-18k·13薪  广州-黄埔区    硕士              汤臣倍健   2000-5000人  食品/饮料/酒水  \n",
       "39  15-22k·13薪      广州    本科              裕丰地产  5000-10000人  房地产租赁/中介  \n",
       "\n",
       "[160 rows x 9 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aa = new_df[['job.labels','job.requireWorkYears','job.title','job.salary','job.dq','job.requireEduLevel','comp.compName','comp.compScale','comp.compIndustry']]\n",
    "aa.columns = ['工作标签','工作年限','工作名称','薪资','地区','学历要求','公司名称','公司规模','公司融资情况']\n",
    "aa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "ebd5e48f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "bb = pd.DataFrame(aa)\n",
    "bb.to_excel('表格.xlsx',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b4f39258",
   "metadata": {},
   "outputs": [],
   "source": [
    "sel ='div.j_result'\n",
    "contents = r.html.find(sel)\n",
    "for content in contents:\n",
    "    print(content.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "e9b5ef4f",
   "metadata": {},
   "outputs": [],
   "source": [
    "sel = 'div.j_result'\n",
    "contents = r.html.find(sel)\n",
    "title = []\n",
    "location = []\n",
    "details = []\n",
    "date = []\n",
    "price = []\n",
    "unit_price = []\n",
    "for content in contents:\n",
    "    content_item = content.text.split('\\n')\n",
    "#    print(content_item[0])\n",
    "    title.append(content_item[0])\n",
    "    location.append(content_item[1])\n",
    "    details.append(content_item[2])\n",
    "    date.append(content_item[3])\n",
    "    price.append(content_item[5])\n",
    "    unit_price.append(content_item[6])\n",
    "# for content in contents:\n",
    "#    print(content.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "0778b7cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "498a41b9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[]\n"
     ]
    }
   ],
   "source": [
    "print(date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "02c01461",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(\n",
    "data= {\n",
    "    'title':title,\n",
    "    'location':location,\n",
    "    'details':details,\n",
    "    'date':date,\n",
    "    'price':price,\n",
    "    'unit_price':unit_price,\n",
    "},\n",
    "index = {i for i in range(len(title))})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "48890996",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>location</th>\n",
       "      <th>details</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>unit_price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [title, location, details, date, price, unit_price]\n",
       "Index: []"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8884f611",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.4"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
